Skip to content

Registered aircraft · 5,086

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:91-21-01-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:91-21-01-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:91-21-01-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:91-21-01-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:91-21-01-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:91-21-01-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.

N9244YParker Aircraft Sales Inc · Wilmington, DEBuilt 1983 · S/N 31P-8414014 N9245YMiles Aviation LLC · Sheridan, WYBuilt 1983 · S/N 31P-8414025 N9246MShenkirsch Consulting Inc · Mammoth Lakes, CABuilt 1993 · S/N 4622149 N9246PSharp Paul C · Modesto, CABuilt 1967 · S/N 24-4745 N9247LGenesis Aviation Enterprises Inc · Fort Lauderdale, FLS/N 31-8152160 N9247PEhrenberg David G · Corning, NYBuilt 1968 · S/N 24-4746 N9247YWest Bend Air Inc · West Bend, WIBuilt 1968 · S/N 31-322 N9248PPajaro Jaison · Burtonsville, MDBuilt 1966 · S/N 24-4627 N924CCSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1966 · S/N 27-3490 N924DCAirmann Leasing LLC · Mount Sterling, KYBuilt 1996 · S/N 4636057 N924RRHigh Timothy Duane · Glenwood, MOBuilt 1977 · S/N 32R-7780450 N924TFRegistered aircraftBuilt 1996 · S/N 27-0218 N9250PBas Part Sales LLC · Greeley, COBuilt 1967 · S/N 24-4747 N9251PSalori Aviation LLC · Centralia, MOBuilt 1967 · S/N 24-4749 N9252POsipov Yuri A · Lomita, CABuilt 1967 · S/N 24-4750 N9253CJetstream LLC · River Forest, ILBuilt 1995 · S/N 4622183 N9253PConway Brandon · Springtown, TXBuilt 1967 · S/N 24-4751 N9255PSalvia Michael · Farmington Hills, MIBuilt 1968 · S/N 24-4754 N9257NJohn Bowman Inc · Fountain, COBuilt 1995 · S/N 4636006 N9258PCessna 79432 LLC · Missoula, MTBuilt 1968 · S/N 24-4757 N9259PChiarini Joshua · Cranston, RIBuilt 1968 · S/N 24-4758 N925BFSandin Robyn · Mc Donald, TNBuilt 2000 · S/N T20608232 N925DBHawk2lane LLC · Newark, DEBuilt 2005 · S/N T18208366 N925TCJarvis Bradley A · North Port, FLBuilt 1981 · S/N 32R-8129013 N9260PRichter Scott J · Eden Prairie, MNBuilt 1996 · S/N 4636044 N9262GChampion Med LLC · Dover, DEBuilt 1995 · S/N 4636017 N9262PReliant Aeroworks LLC · Sanger, TXBuilt 1968 · S/N 24-4761 N9262YTwin Star Montana LLC · Kalispell, MTBuilt 1984 · S/N 31P-8414033 N9263KCrook Michael J · Paradise, UTBuilt 1976 · S/N 32R-7680205 N9263PWhitacre John B III · Waynesburg, OHBuilt 1968 · S/N 24-4762 N9264PBeil Richard P Trustee · Caroline, WIBuilt 1968 · S/N 24-4763 N9267PNickravesh Niknam J · San Jose, CABuilt 1968 · S/N 24-4767 N9268PAts Inc · Chicago, ILBuilt 1968 · S/N 24-4768 N926HBAwmr LLC · Conroe, TXBuilt 1975 · S/N 317552007 N9270PPenn Landmark Corp · Pinehurst, NCS/N 24-4770 N92714Registered aircraftBuilt 1996 · S/N 4636042 N92728Washington International Aviation LLC · Washington, DCBuilt 1996 · S/N 4636050 N9272PH&R Aircraft LLC · Kansas City, MOBuilt 1968 · S/N 24-4772 N9272YIal Corp · Lewes, DEBuilt 1984 · S/N 31P-8414039 N9274PMurray John F · Crystal Lake, ILBuilt 1968 · S/N 24-4774 N92765N92765 Inc Trustee · Wilmington, DEBuilt 1996 · S/N 4636070 N9276PHansen Stephen J · Redmond, WAS/N 24-4776 N9279PArdis Mitchell Farm LLC · Winnsboro, TXBuilt 1968 · S/N 24-4780 N927DMGoat Rancho LLC · Euless, TXS/N 32-40225 N927PTReds Asset Managers LLC · Pottsville, PABuilt 1976 · S/N 27-7754008 N9280KN9280k LLC · Miami, FLBuilt 1997 · S/N 4636109 N92811Stephen Beazley Builders Inc · Evans, GABuilt 1996 · S/N 4636076 N9281BClear View Inc · Fort Smith, ARBuilt 1996 · S/N 4636074 N92821Aerinova Inc · Mattoon, ILBuilt 1997 · S/N 4636081 N92835Ruff Aviation LLC · Asheville, NCBuilt 1997 · S/N 4636097

Back to AD 91-21-01 R1