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.

N2478YHockenson Roy D · Auburn, WABuilt 1962 · S/N 17249778 N2479BPac 2 LLC · Clinton, IABuilt 2001 · S/N 172S8806 N2479LMoore Joseph A · Kingwood, WVBuilt 1966 · S/N 17255679 N2479MSt Thomas Jet Center Flying Club LLC · Lewes, DES/N 172S10581 N2479U2479u Aviation LLC · Fernandina Beach, FLBuilt 1963 · S/N 17250079 N2479YDmac Aircraft LLC · Savannah, GABuilt 1962 · S/N 17249779 N247APNorth Joseph · Cocoa, FLBuilt 1970 · S/N 17259066 N247AUPeregrine Howard Partners II Lp · New Orleans, LABuilt 2024 · S/N 172S13264 N247DLCentral Florida Flight LLC · Ocoee, FLBuilt 1966 · S/N 17254201 N247LWHailey & Harmony Enterprises LLC · Las Vegas, NVS/N 172RG0314 N2480LStephens Ryan J · Dallas, PABuilt 1966 · S/N 17255680 N2480URaczynski Adam · Far Rockaway, NYBuilt 1963 · S/N 17250080 N2481LGhaemmaghami Ommid · Mckinney, TXBuilt 1966 · S/N 17255681 N2481YFellers Farms LLC · Burlington, OKBuilt 1962 · S/N 17249781 N2482LTrubowicz Maciej Piotr · Cornelius, NCBuilt 1966 · S/N 17255682 N2484LLuv2fly LLC · San Antonio, TXS/N 17255684 N2484UFiske James K · North Andover, MABuilt 1963 · S/N 17250084 N2485YMcdonald Gregory S · Mena, ARBuilt 1962 · S/N 17249785 N2486YCarfinder LLC · Huntington Station, NYBuilt 1962 · S/N 17249786 N2487UBaske Scott E · Hanna, INBuilt 1963 · S/N 17250087 N2487YBradley Jeff C · Schertz, TXS/N 17249787 N2488USchafer Gerhard Walter · Fairbanks, AKS/N 17250088 N2489LCalifornia Aviation Services Inc · Riverside, CABuilt 1966 · S/N 17255689 N2489UKauachi Melik · Brownsville, TXS/N 17250089 N248ERUnverferth Gregory T · Fort Jennings, OHS/N 17271977 N248GTHansen Nelse · Lawrenceville, GABuilt 1981 · S/N 17274572 N248RAReynolds Darryl G · Wills Point, TXBuilt 2000 · S/N 172S8562 N248SFEl Prop Plane I LLC · Metairie, LABuilt 2025 · S/N 172S13443 N248ZLightsey Aviation LLC · Jacksonville, FLBuilt 1967 · S/N 17256247 N2490LWimberly Thomas F III · Bend, ORBuilt 1966 · S/N 17255690 N2490UBredbenner Carl A · Dalmatia, PABuilt 1963 · S/N 17250090 N2491LMcgivern James · San Pedro, CABuilt 1966 · S/N 17255691 N2493YBeauchamp Chris L · Anacortes, WABuilt 1962 · S/N 17249793 N2495Lynch Sean L · Brighton, ILBuilt 1978 · S/N 17270282 N2495UKoelbl Aviation LLC · Whitesboro, TXBuilt 1963 · S/N 17250095 N2496LSequeira Michael J · Troy, MOBuilt 1966 · S/N 17255696 N2496UKloker Daniel E · Owasso, OKBuilt 1963 · S/N 17250096 N2496YSchwab George E · Stillwater, OKBuilt 1962 · S/N 17249796 N2497EBenham Aviation LLC · Enid, OKBuilt 1978 · S/N 17271303 N2497YSouth Plains Precision Ag · Plainview, TXBuilt 1962 · S/N 17249797 N2498LJohn Kit M · Shoshone, IDBuilt 1966 · S/N 17255698 N2498URegistration Pending · Royal, ARRegistration pendingBuilt 1963 · S/N 17250098 N2498YBargabos Earthworks Inc · Peterboro, NYBuilt 1962 · S/N 17249798 N2499YTompos Michael J · Mendota Heights, MNBuilt 1962 · S/N 17249799 N249FSAdvanced Charter & Instruction LLC · Costa Mesa, CABuilt 2005 · S/N 17281249 N249JSCrystal Coast Training LLC · Kinston, NCBuilt 2023 · S/N 172S13011 N249KFf22 LLC · Scottsdale, AZBuilt 2022 · S/N 172S12830 N249NYWoldt Wayne E · Raymond, NEBuilt 1978 · S/N 17271032 N24AFAbove & Beyond Aviation LLC · Austin, TXBuilt 1998 · S/N 17280439 N24BQAb Prop Plane II LLC · Metairie, LABuilt 2024 · S/N 172S13217

Back to AD 90-06-03 R1