Skip to content

Registered aircraft · 20,683

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:90-06-03-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:90-06-03-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:90-06-03-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:90-06-03-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:90-06-03-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:90-06-03-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.

N6270RAbout Time Aviation · Springfield, ORBuilt 1979 · S/N 172RG0132 N6271ENate Abel Flying Club · Fort Worth, TXBuilt 1958 · S/N 46371 N62726Xing Kong Aviation Service LLC · Atwater, CAS/N 17281529 N6272EFeauto Aviation Inc · Saint Cloud, FLBuilt 1958 · S/N 46372 N6273EBunner Corin Anthony · Murfreesboro, TNBuilt 1959 · S/N 46373 N62740Doomac LLC DBA · Peyton, COBuilt 1981 · S/N 17275331 N6274DOracle Aviation LLC · Omaha, NEBuilt 1979 · S/N 17272685 N6274EHuff Air LLC · Uvalde, TXBuilt 1959 · S/N 46374 N6274VDollbaum Robert A · Southfields, NYBuilt 1980 · S/N 172RG0604 N6275RFoode Frank J · Cordova, AKBuilt 1979 · S/N 172RG0137 N62770Hog Island Flying LLC · Winter Park, FLBuilt 2008 · S/N 172S10747 N6277DBockstiegel Bill C · Leadville, COBuilt 1979 · S/N 17272687 N6278EJ K Sparks Inc · Lutz, FLBuilt 1959 · S/N 46378 N6278GAvila Sarah · Long Beach, CAS/N 17273586 N6278RCress LLC · Dover, DEBuilt 1979 · S/N 172RG0139 N62796Kane Chuck · Thousand Oaks, CABuilt 1981 · S/N 17275337 N6279VRegistered aircraftBuilt 1980 · S/N 172RG0605 N627ARTextron Aviation Inc · Wichita, KSBuilt 2026 · S/N 172S13594 N627CTCoast Flight Training And Management Inc · San Diego, CABuilt 2006 · S/N 17281336 N627EREmbry-Riddle Aeronautical University Inc · Prescott, AZBuilt 2023 · S/N 172S13063 N627SPFxe Flightcenter Corp · Fort Lauderdale, FLBuilt 2000 · S/N 172S8621 N6280RBredvold Daniel M · Mendota Heights, MNBuilt 1979 · S/N 172RG0141 N6280VHenneberry Joseph Paul III · Pilot Hill, CABuilt 1980 · S/N 172RG0606 N6281EPlunk Ben · Mesquite, TXBuilt 1959 · S/N 46381 N6282DPlane Junkies LLC · Dover, DEBuilt 1979 · S/N 17272689 N6283VAxley Micheal S · Portland, ORBuilt 1980 · S/N 172RG0608 N6284ECastle Donald L · Auburn, CABuilt 1959 · S/N 46384 N6284RTop Aircraft Leasing LLC · Wilmington, DEBuilt 1979 · S/N 172RG0144 N62855Pterosaur LLC · Cumming, GABuilt 1981 · S/N 17275342 N6285FWright Base Flight Training LLC · Tullahoma, TNBuilt 1980 · S/N 17273180 N62862Freeflight Aviation LLC · Allentown, NJBuilt 1981 · S/N 17275343 N62875L&W Leasing LLC · Smyrna, TNBuilt 2008 · S/N 172S10756 N62876American Patrols Inc · Midland, TXS/N 17275346 N6287EClemons Martin · Butte, MTS/N 46387 N62887Carter Jeffrey P · Parker, COBuilt 1981 · S/N 17275350 N6288DRickwalt David L · Fort Mohave, AZS/N 17272694 N6288EMccardy Derk · Torrance, CABuilt 1959 · S/N 46388 N62890Fixed Wing Holding Co Inc · Pembroke Pines, FLBuilt 1981 · S/N 17275351 N62891Wings Over Texas Holdings LLC · Denton, TXS/N 17275352 N6289DYecny Enterprises Inc · San Luis Obispo, CABuilt 1979 · S/N 17272695 N6289EMaverick Jets LLC · Vineburg, CABuilt 1959 · S/N 46389 N6289FSbk Aviation LLC · Festus, MOBuilt 1979 · S/N 17273181 N628CTAb Prop Plane II LLC · Metairie, LABuilt 2022 · S/N 172S12897 N628JCDelaney Patrick James · Marion, TXBuilt 1974 · S/N 17262911 N628LAAircraft Holdings LLC · Scottsdale, AZBuilt 2024 · S/N 172S13126 N628RBBrown Michael C · Erie, KSBuilt 1972 · S/N 17260622 N62901Bates Field Aero Club Inc · Mobile, ALBuilt 1981 · S/N 17275355 N6290EConnell Mark Stephen · Melbourne, FLBuilt 1959 · S/N 46390 N6290VDelta Sierra Aviation LLC · White Salmon, WABuilt 1980 · S/N 172RG0610 N62918Neron II LLC · New Smyrna Beach, FLS/N 17275359

Back to AD 90-06-03 R1