Skip to content

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.

N9269NLevenfeld Yuri · Brookhaven, GABuilt 1978 · S/N 24-0751 N926BWTrade Winds Aviation Holdings LLC · Lewes, DEBuilt 1974 · S/N 770-74 N926DSJsrg Aviation LLC · Incline Village, NVBuilt 1981 · S/N 24-1236 N926JPJl Aviation LLC · Crestwood, KYBuilt 2004 · S/N 490-2004 N926KRNewton Christopher F · Kill Devil Hills, NCBuilt 1989 · S/N 24-3120 N926MNPtw Consulting LLC · Atlanta, GABuilt 1971 · S/N 17260325 N92701Kyllo Jeffrey K · Larimore, NDBuilt 1975 · S/N 18802070T N92704Gull Wing Flight LLC · Pt Pleas Bch, NJBuilt 1973 · S/N 17261605 N9270MMcmanus Nicholas A · Versailles, KYBuilt 1966 · S/N 1211 N9270VPhilippi Harrold Mark · Metairie, LABuilt 1969 · S/N 690073 N9271MCantelmi Richard L · Bethlehem, PABuilt 1966 · S/N 3459 N9271RUpwind Aviation LLC · Mitchell, SDBuilt 1978 · S/N R18200676 N92720Registration Pending · Champaign, ILRegistration pendingS/N 17261608 N92722Bryant David A · Walhalla, SCBuilt 1973 · S/N 17261609 N9272HBlackbird 71 LLC · Rockford, ILBuilt 1975 · S/N 17266060 N9272MSearle Jacob · Kuna, IDBuilt 1966 · S/N 3460 N9272RFarrow Sammie N Jr · Cordele, GABuilt 1975 · S/N 18802200T N92747Wiles Donald · Shrewsbury, MABuilt 1973 · S/N 17261613 N9274HWings Over Texas Holdings LLC · Denton, TXBuilt 1975 · S/N 17266062 N9274MGibson Rodney A · Saluda, NCBuilt 1966 · S/N 1213 N92753Mccollum J R · Mount Pleasant, TXBuilt 1973 · S/N 17261614 N9275TMoore Joseph P · Stillwater, OKBuilt 1978 · S/N 38-78A0312 N9275VBridges Linda Arnett · Friendswood, TXBuilt 1969 · S/N 690076 N9276VBlair Jason C · Elbert, COS/N 690062 N92777Macatawa Flyers Inc · Allegan, MIBuilt 1973 · S/N 17261616 N9277HChorman Spraying LLC · Milton, DEBuilt 1975 · S/N 17266065 N9277MHodde James C · Mckinney, TXBuilt 1966 · S/N 3462 N9277VAoa Aviation Service LLC · Waxhaw, NCBuilt 1969 · S/N 690077 N92789N5746u LLC · Dover, DES/N 17261619 N9278MIlya Sevrugin · Santa Clarita, CABuilt 1966 · S/N 1215 N9278TSanderson Nicholas DBA · Olivet, MIBuilt 1978 · S/N 38-78A0314 N927ALBravo II Sierra LLC · Dallas, TXBuilt 1980 · S/N 24-1048 N927MPPrebish Matthew · Heath, TXBuilt 1980 · S/N R18201569 N927SANpg Group LLC · Missoula, MTBuilt 2003 · S/N 927-2003 N927TCWings Over Texas Holdings LLC · Denton, TXBuilt 1974 · S/N 17264152 N927WTHaugen Delos L · Burlington, NDBuilt 1966 · S/N 438 N9280MRiley Dean A · Friday Harbor, WABuilt 1972 · S/N 17260490 N9280VReifel Harry C Jr · Boxford, MABuilt 1969 · S/N 690065 N92810Dilse Brian R · Grand Forks, NDBuilt 1973 · S/N 17261626 N92817Millner James W Sr · Soldotna, AKBuilt 1973 · S/N 17261628 N9281MJakobsen Anders M · Norcross, GAFirst renewal noticeBuilt 1966 · S/N 3463 N9281RBmg Aviation Leasing LLC · Bloomington, INBuilt 1978 · S/N R18200678 N9281VJohnson Jerry W · Westlake, TXBuilt 1969 · S/N 690077 N9282MRainey Michael N · Cleveland, TNBuilt 1966 · S/N 3464 N92837Staszak Sandra · Martinsville, ILBuilt 1973 · S/N 17261631 N9283CFoerschler Dale · North Aurora, ILBuilt 1980 · S/N 17273783 N9283MHazelswart India A · Chase City, VABuilt 1966 · S/N 670001 N9283RAllied Sprayers Inc · Hawley, TXBuilt 1975 · S/N 18802211 N92845Hainet Aero LLC · Wilmington, DEBuilt 1973 · S/N 17261633 N9284TGarrett Randall F · Fort Walton Beach, FLBuilt 1978 · S/N 38-78A0319

Back to AD 80-25-07 R1