Registered aircraft · 25,368

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.

N9973BMajor Air LLC · Charleston, SCBuilt 1982 · S/N 172RG1103 N9973TMenno David L · Lancaster, NYBuilt 1978 · S/N 38-78A0268 N99744Christiansen Aviation LLC · Wilmington, DEBuilt 1985 · S/N 17276503 N9974BAppalachian Aviation LLC · Harrisonburg, VABuilt 1982 · S/N 172RG1104 N9974TArgos Retail LLC · Mcallen, TXBuilt 1978 · S/N 38-78A0269 N99750Kool Wings Leasing LLC · Indianapolis, INBuilt 1985 · S/N 17276504 N99759Civil Air Patrol · Maxwell Afb, ALBuilt 1985 · S/N 17276506 N99765Tactical Intergriated Training Solutions LLC · Colorado Springs, COBuilt 1985 · S/N 17276507 N9976TAlvarez Humberto H · Kingsville, TXBuilt 1978 · S/N 38-78A0270 N9976YRogue Air LLC · Miller, SDBuilt 1964 · S/N 7ECA-1 N99770Civil Air Patrol · Maxwell Afb, ALBuilt 1985 · S/N 17276508 N9977JBoening Bros Dusting & Spraying Inc · Floresville, TXBuilt 1982 · S/N T18803906T N9977VLunceford James A · Stanchfield, MNBuilt 1974 · S/N 17264595 N99783Alexander Todd · Westhampton, MABuilt 1985 · S/N 17276510 N9978TMaletich Dustin S · Pilot Rock, ORBuilt 1978 · S/N 38-78A0271 N9979CVan Lehn Sethany A · Frederick, MDBuilt 1978 · S/N R18200495 N997DDark Horse Express LLC · Hendersonville, TNBuilt 1978 · S/N 24-0654 N997REEuroaviation Inc Trustee · KematenBuilt 1966 · S/N 961 N997SEAero Equities LLC · Ventura, CABuilt 1978 · S/N 17271571 N997WTRxy LLC · Gilbert, AZBuilt 2023 · S/N 1222 N9981TLadegard Paul E · Wasilla, AKBuilt 1978 · S/N 38-78A0272 N9981VWeeks Richard F Jr · Portsmouth, NHFirst renewal noticeBuilt 1974 · S/N 17264599 N99826Cp Aviation · Santa Paula, CABuilt 1985 · S/N 17276514 N9982YChin-Loy Christopher Wayne Trustee · Tamarac, FLBuilt 1982 · S/N 21064659 N99832Watch Ya Head Aviation 1 LLC · Zionsville, INBuilt 1985 · S/N 17276515 N9983VHeyman William L · Santa Fe, NMBuilt 1974 · S/N 17264601 N9984CTucker Harry B · Lexington, NCBuilt 1978 · S/N R18200496 N9984VValley Drug Of Malta Inc · Malta, MTBuilt 1974 · S/N 17264602 N9985BJacks Charles D · Morse, LABuilt 1982 · S/N 172RG1107 N9986SKaneaster Richard W · Port Orange, FLBuilt 1996 · S/N 1218-96 N99870Christiansen Aviation LLC · Wilmington, DES/N 17276519 N99871Civil Air Patrol · Maxwell Afb, ALS/N 17276520 N99872Rps Holdings N99872 LLC · Magnolia, TXS/N 17276521 N9987VKaplan Steven M · North Monmouth, MES/N 172-64605 N99881Civil Air Patrol · Maxwell Afb, ALS/N 17276523 N99885Az2025 LLC · Miami, FLS/N 17276524 N9988VLenoir Aviation Club Inc · Lenoir, NCFirst renewal noticeBuilt 1974 · S/N 17264606 N9989VPace Dusty · Pendleton, ORBuilt 1974 · S/N 17264607 N998BHayton James B · Sedro Woolley, WABuilt 1967 · S/N 7KCAB-47 N998BCSky High Homes LLC · Etna, WYBuilt 2018 · S/N 586-2018 N998RASchubert Brothers Aviation Inc · Canandaigua, NYBuilt 1973 · S/N 17261672 N998SEUtter Albert · Fort Myers, FLBuilt 1988 · S/N 17274025 N998SMTiger Tach Aviation LLC · Henderson, NVBuilt 1998 · S/N 24-3426 N9990BAurora-Flight LLC · Commerce Township, MIBuilt 1982 · S/N 172RG1109 N9990VCompass Aviation Inc · Shelby, NCBuilt 1974 · S/N 17264608 N99917Anderson Cody Jon · Orono, MEBuilt 1986 · S/N 17276527 N9991BTaft Leasing LLC · Bloomfield, NMBuilt 1982 · S/N 172RG1110 N9991EWings Flight Enterprises Inc · Danville, KYS/N 17272308 N9991GSale Reported · Staten Island, NYSale reported, canceledBuilt 1979 · S/N 17273639 N9991VSafeway Flying Club Inc · Denmark, WIBuilt 1975 · S/N 17264609

Back to AD 80-25-07 R1