Registered aircraft · 25,370

Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.

Query with SQL

SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:80-25-07-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:80-25-07-R1') ORDER BY n_number

duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
  WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:80-25-07-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:80-25-07-R1')
  ORDER BY n_number"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:80-25-07-R1')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:80-25-07-R1')
ORDER BY n_number

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N24981R&R Aero Services LLC · Eden Prairie, MNBuilt 1977 · S/N 15280490 N24986Charlston Michael M · Haleiwa, HIBuilt 1977 · S/N 15280495 N2498DGenzlinger Chad A · Foresthill, CABuilt 1978 · S/N 38-79A0334 N24995Stiles Robert K · Lynden, WABuilt 1977 · S/N 15280502 N24998Airplanes And Helicopters Of Oregon LLC · Sisters, ORBuilt 1977 · S/N 15280503 N2499AEhrich Anthony K · Rockham, SDS/N 38-78A0718 N2499PPancio Paul · Lagrangeville, NYS/N 38-79A1013 N249DMAnderson Spencer D · Lafayette, LAS/N 2514 N249MAQueen City Flying LLC · Helena, MTBuilt 2004 · S/N 943-2004 N249NYWoldt Wayne E · Raymond, NEBuilt 1978 · S/N 17271032 N249RAApel Thomas G · Edmond, OKBuilt 2004 · S/N 1371-2004 N249SFCasarez David W · Carmel Valley, CABuilt 2000 · S/N 418-2000 N24BSSiemers Warren G · Fort Collins, COBuilt 1967 · S/N 670495 N24BYOur Sky LLC · Woodinville, WABuilt 2004 · S/N 946-2004 N24CManganaro Andrew J · Xenia, OHBuilt 1985 · S/N 1011 N24CVPacific Air Flight School LLC · Long Beach, CABuilt 1977 · S/N 17270186 N24ELDye Eric M · Winters, CABuilt 1979 · S/N R18200884 N24GVBoyd Aviation LLC · Nashville, TNBuilt 1975 · S/N 17265760 N24KKFlying High Again LLC · Mt Juliet, TNBuilt 1975 · S/N 17266333 N24LTPinestate Aviation LLC · Glenburn, MEBuilt 1981 · S/N 17275466 N24MKPiispanen Norman C · Fairbanks, AKBuilt 1969 · S/N 151 N24NHBeyer Roger · Paw Paw, MIBuilt 1981 · S/N 21064545 N24SDHall Mike · Houston, TXBuilt 2022 · S/N 624-2022 N24SZJordan James David · Helena, ALBuilt 2010 · S/N 1097-2010 N24TBDalks Leasing Inc · Wilmington, DEBuilt 1982 · S/N P21000799 N24TJNeilson Keith B · East Lyme, CTBuilt 1976 · S/N 579-76 N24YHKoch Bernard L · Arriba, COBuilt 1974 · S/N 782-75 N2500ERudloff Uwe K Trustee · Lake Village, INS/N 38-78A0474 N2500ZGuldi James E · Port Orange, FLBuilt 1977 · S/N 991-77 N2501FAerowood Aviation LLC · Monroe, NCBuilt 1965 · S/N 7ECA140 N2501GN2501g LLC · Columbia, CABuilt 1967 · S/N 112 N2501ZSmith Glenn G Jr · Ardmore, OKBuilt 1977 · S/N 1219-77 N25023Linero Jose J · San Juan, PRBuilt 1979 · S/N 38-79A0984 N25028East Hill Flying Club Inc · Ithaca, NYBuilt 1977 · S/N 15280505 N2502FDexter Fred H · Live Oak, FLS/N 152 N2502ZByrne Gary W DBA · Georgetown, INBuilt 1977 · S/N 328-77 N2503FSuperior Food Distributors LLC · Naples, FLBuilt 1965 · S/N 153 N2503PAlpha Aviation Holdings Group LLC · Raleigh, NCS/N 38-79A1014 N2503VAlpha Aviation Holdings Group LLC · Raleigh, NCBuilt 1982 · S/N 38-82A0069 N2503ZAviation Financial Corp · Torrance, CABuilt 1977 · S/N 613-77 N25047Sunrise Aviation Inc · Ormond Beach, FLBuilt 1977 · S/N 15280514 N2504FJohnson Scott W · Saline, MIBuilt 1965 · S/N 38 N25053Southwinds Export Inc · Kissimmee, FLNon-citizen corporation, flight hours not reportedS/N 15280517 N25057Nino Jose · Kenilworth, NJBuilt 1977 · S/N 15280520 N2505FAcme Anvil LLC · Parker, COBuilt 1965 · S/N 127 N2505KIvy James E · Alba, TXBuilt 1979 · S/N 38-79A0669 N2505ZStratton Robert Stephen · Boulder, COFirst renewal noticeBuilt 1977 · S/N 330-77 N25062Stratton James P · Lubbock, TXBuilt 1979 · S/N 38-80A0026 N2506GInternational Air Services Inc Trustee · Carson City, NVBuilt 1979 · S/N 38-79A0547 N2506LColumbus State Community College · Columbus, OHBuilt 1979 · S/N 38-79A0740

Back to AD 80-25-07 R1