Skip to content

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.

N44CCoyne Greg · Hondo, TXBuilt 1979 · S/N P21000311 N44CAWiley Commercial Property Consulting Inc · Aitkin, MNBuilt 1980 · S/N R18201556 N44CUAirstar Aviation LLC · Manawa, WIBuilt 1976 · S/N 17268037 N44DMGorge Winds Aviation Inc · Fairview, ORBuilt 1973 · S/N 17261488 N44ECN44ec LLC · Caddo Mills, TXBuilt 1980 · S/N 21063972 N44EEEchemann Thomas A · Sidney, OHBuilt 1979 · S/N 21063723 N44HKBradt Joseph J · Inver Grove, MNBuilt 1997 · S/N 79597 N44KPHargrave Margarite D · Seattle, WABuilt 1978 · S/N 172-70904 N44LKCessna Skyhawk LLC · Parker, COFirst renewal noticeBuilt 1979 · S/N 17273400 N44NSHunt Lionel Mark · Groveland, CABuilt 1979 · S/N 24-0913 N44NTTucker Nicholas B · La Canada, CABuilt 1981 · S/N 21064531 N44SJHarpreet Sandhu · Livermore, CABuilt 1977 · S/N 0752 N44STTakvorian Sevag · West New York, NJBuilt 1979 · S/N 17271609 N44TSNapier Mark R · New Bern, NCBuilt 1993 · S/N 24-3321 N44WBEvans Jerry R · York, PABuilt 1980 · S/N A1520909 N44ZTJensen Erik N · Madison, WIBuilt 1992 · S/N 24-3247 N44ZWTurner Robert H · San Diego, CABuilt 1977 · S/N 322-77 N4500KEaston Gregory D · Montrose, COBuilt 1978 · S/N P21000201 N4501EOptima Aviation LLC DBA · Lewisville, TXS/N 17271614 N4501HBrown Kevin · San Dimas, CABuilt 1978 · S/N 24-0750 N45060Stone Eric · Cedarpines Park, CABuilt 1976 · S/N 177RG1091 N45086Dahl Ken L · Granite Falls, MNBuilt 1976 · S/N 177RG1092 N4509HGolding Lee · Brookline, MOBuilt 1978 · S/N 24-0753 N4509JHill Curtis E · Bancroft, IDBuilt 1981 · S/N T18803741T N450CSCbcb Aircraft LLC · Colfax, WABuilt 1979 · S/N P21000214 N450SCSky West Aviation Inc Trustee · Albuquerque, NMS/N P2100294 N450SEAok LLC · Omaha, NES/N P21000605 N4511EN2893e LLC · Reno, NVBuilt 1978 · S/N 17271619 N4511HVeritas Urbis Economics LLC · Groveland, CABuilt 1978 · S/N 24-0755 N45128Bowker James K · Ponca City, OKBuilt 1976 · S/N 177RG1093 N4517HHopkins Larry G · Cameron, MTBuilt 1979 · S/N 24-0785 N45188Arias Armando D · Santa Cruz, CABuilt 1976 · S/N 177RG1095 N45193Bostwick James · Melrose, NMBuilt 1976 · S/N 177RG1096 N451KWKw Plastics · Troy, ALBuilt 1978 · S/N 451-78 N451PCParkland College · Champaign, ILBuilt 2024 · S/N 1220-2024 N451PSUpside Down Aero LLC · Aberdeen, IDBuilt 1976 · S/N 193-76 N451SABobbitt Cole T · Jasper, GABuilt 2004 · S/N 944-2004 N4522HGlaser Arthur E · Crest Hill, ILBuilt 1979 · S/N 24-0789 N4522KGoodman Jack A · Memphis, TNBuilt 1979 · S/N P21000209 N45248Lewis Steven A · Mesa, AZBuilt 1976 · S/N 177RG1098 N4524HSaka M Demir Trustee · Quincy, ILBuilt 1979 · S/N 24-0790 N45250Thiele Klaus U · San Diego, CABuilt 1976 · S/N 177RG1099 N4526HJohnston Robert K · Sylvania, GABuilt 1979 · S/N 24-0791 N45277Fritz Kurt C · Montoursville, PABuilt 1976 · S/N 177RG1100 N4528JRobertson Crop Dusting Service Inc · South Haven, MIBuilt 1980 · S/N T18803744T N452RAMelvin Mark · Berkeley, CABuilt 1979 · S/N R18200634 N452SPhantom Aviation LLC · Portland, ORBuilt 1992 · S/N 689-92 N452XJohnson Robert Gail Jr · Yorba Linda, CAS/N 24-3357 N4530EAig Aeronautics LLC · San Juan, PRBuilt 1978 · S/N 17271621 N45312Heap Agriculture Service LLC · Stronghurst, ILBuilt 1976 · S/N 177RG1102

Back to AD 80-25-07 R1