Skip to content

Registered aircraft · 5,102

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:81-12-06-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:81-12-06-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:81-12-06-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:81-12-06-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:81-12-06-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:81-12-06-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.

N9233PBlandina Leon V · New Hudson, MIBuilt 1967 · S/N 24-4731 N9235PJen Lyn Inc · Wilmington, DEFirst renewal noticeBuilt 1967 · S/N 24-4734 N9235YKamasano LLC · Highland, CABuilt 1983 · S/N 31P-8414020 N9236PTasso Aviation LLC · Orrville, ALS/N 24-4735 N9237PCloud Climibers LLC · Lexington, KYBuilt 1967 · S/N 24-4736 N9238PPylant Eric Jon · Arnold, CABuilt 1967 · S/N 24-4737 N9238WMansour Muhamad A · Wichita, KSBuilt 1967 · S/N 28-10908 N9239YDelgado John F · San Antonio, TXBuilt 1984 · S/N 31P-8414040 N923JSSankey Aviation LLC · Warminster, PABuilt 2005 · S/N T18208390 N923SDFresno County Sheriffs Department · Fresno, CABuilt 2001 · S/N T20608342 N9241PGaskill Jeffrey V · Weston, MOS/N 24-4740 N9242PDekervor Marc Phillippe II · La Mesa, CAS/N 24-4741 N9243PKanne Michael J · Des Moines, IABuilt 1967 · S/N 24-4742 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

Back to AD 81-12-06 R1