Skip to content

Registered aircraft · 17,025

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:72-03-03-R3') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:72-03-03-R3') 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:72-03-03-R3')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:72-03-03-R3')
  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:72-03-03-R3')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:72-03-03-R3')
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.

N150DECopaair Maintenance Services Inc · Indiantown, FLBuilt 1972 · S/N 15073849 N150DKShipe Jacqueline M · Louisville, TNBuilt 1968 · S/N 15069738 N150DLLedford Joseph Daniel · Cedartown, GAS/N 15075555 N150DPVendetti Michael J · Olney, MDBuilt 1970 · S/N 15072356 N150ETjelta Peter A · Sheyenne, NDBuilt 1967 · S/N 15066502 N150EBRegistered aircraftS/N 15072790 N150EGGreene Harry L · Waipahu, HIBuilt 1969 · S/N 15071635 N150EHPouya Hamid · San Jose, CABuilt 1969 · S/N 15070883 N150EMArman Michael P · Oak Hill, FLBuilt 1967 · S/N 15066362 N150EWGlazier Matthew S · Presque Isle, MEBuilt 1968 · S/N 15068457 N150FJSale Reported · Crystal, MNSale reportedBuilt 1969 · S/N 15071001 N150FLBerry Jeffrey Thomas · Clovis, CABuilt 1969 · S/N 15070938 N150FTLevine Albert E · Bloomfield, CTS/N 15065352 N150GRSoaring For Christ LLC · Big Lake, AKS/N 15066875 N150HWilliams Zachary · Jackson, MIS/N 15063910 N150HARegistration Pending · Albuquerque, NMRegistration pendingBuilt 1969 · S/N A1500100 N150HFRegistration Pending · Garden Grove, CARegistration pendingBuilt 1965 · S/N 15062350 N150HRFeliciano Carlos A · Adjuntas, PRBuilt 1967 · S/N 15067248 N150HVExperimental Aircraft Association Inc · Oshkosh, WIS/N 15066657 N150JGoode Stephen C · Canton, TXS/N 15072750 N150JJMedic Choppers LLC · Springdale, ARBuilt 1970 · S/N 15072231 N150JVHorizon Dreams LLC · Homer, GABuilt 1973 · S/N 15075395 N150JWSheely Kevin L · Lima, OHBuilt 1966 · S/N 15065680 N150KBWord James A · Honey Grove, TXS/N 15070723 N150KCPositive Rate Aviation LLC · Plano, TXBuilt 1972 · S/N 15074254 N150KNMiller Kirk E · Ellendale, NDS/N 15066897 N150KPRegester Stephen J · Roan Mountain, TNBuilt 1966 · S/N 15065795 N150LStillwell Dennis L · Cascade, IDBuilt 1973 · S/N 15075206 N150LAEdwards Kellee L · Carson City, NVBuilt 1972 · S/N 15073266 N150LJL&C Aviation LLC · Trevorton, PABuilt 1971 · S/N 15072865 N150LK92nd West Aviation Inc · Lonoke, ARBuilt 1966 · S/N 15065029 N150LSTrout David Lee · Lebanon, INS/N 15074694 N150MHHousley William M · Jasper, ALS/N 15074821 N150MWWoods Mark H · Las Vegas, NVBuilt 1974 · S/N 15075454 N150NVAltom Chase S · Medford, ORBuilt 1968 · S/N 15069140 N150PCMills Timothy L · Powell, OHBuilt 1967 · S/N 15066257 N150PEAviator Air Flight School LLC · Grand Prairie, TXBuilt 1966 · S/N 15065823 N150PHJr Imaging Logistics Inc · Pasco, WABuilt 1969 · S/N 15071474 N150PMDurand Jennings · Evanston, ILBuilt 1970 · S/N 15072168 N150PWCampbell Andrew H · Sammamish, WABuilt 1966 · S/N 15063380 N150QWard David T · Ewa Beach, HIBuilt 1969 · S/N 15070215 N150RZBhat Shaffin · Sparta, NJBuilt 1974 · S/N 15074929 N150SHArnold Drusilla · Descanso, CABuilt 1969 · S/N 15071506 N150SQEasterling John · Littlerock, CAS/N 15070589 N150SWN W Aviators Inc · Troutdale, ORBuilt 1968 · S/N 15068868 N150TNExecutive Wings LLC · Bolivar, TNBuilt 1968 · S/N 15069553 N150UKMarshall Christoper E · Boise, IDBuilt 1973 · S/N A1500470 N150VMRegistered aircraftBuilt 1969 · S/N 15071200 N150VTFly Vermont LLC · Swanton, VTS/N 15072813 N150WNDombert Dylan D · Navarre, FLBuilt 1973 · S/N 15075320

Back to AD 72-03-03 R3