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.

N2XCMiller Virgil J · Milton Freewater, ORS/N 17266833 N3000UMerrell Warren W · Idalou, TXBuilt 1963 · S/N 17250600 N3001UPrairie Flyers · Rocky Ford, COBuilt 1963 · S/N 17250601 N3003ETuskegee Airmen National Historical Museum · Detroit, MIBuilt 1978 · S/N 17271400 N3008EShore Gerald E · Inez, TXBuilt 1978 · S/N 17271401 N300KXAtp Aircraft 2 LLC · Wilmington, DEBuilt 2015 · S/N 172S11607 N300KZDependable Aviation LLC · Cartersville, GABuilt 1961 · S/N 17248746 N300LCRobinson Russell J · Bridgeport, TXBuilt 1973 · S/N 17261520 N300PSRight Coast Ventures LLC · Royse City, TXBuilt 1968 · S/N 17257501 N300QRPdq Flight Inc · Garden City, NYBuilt 1979 · S/N 17273539 N3010UWestfly LLC · Kalispell, MTBuilt 1963 · S/N 17250610 N3011FGordon Air Services Inc · Miami, FLBuilt 1974 · S/N 17263447 N3012EDamschroder Rex A · Fremont, OHBuilt 1978 · S/N 17271402 N3015ECuevas Ernesto · Orlando, FLBuilt 1978 · S/N 17271404 N3016UValley Wings Flight School LLC · Harlingen, TXS/N 17250616 N3017URivera Michael R · Magnolia, TXBuilt 1963 · S/N 17250617 N30184Cp Aviation Inc · Santa Paula, CABuilt 1974 · S/N 17264125 N301CFSunrise Aviation Inc · Ormond Beach, FLBuilt 2002 · S/N 17281135 N301DPEvans Jack · Albuquerque, NMS/N 17268863 N301JRTropitech Inc · San Juan, PRBuilt 1973 · S/N 17261555 N301NDPutzke Becky A · Fort Ripley, MNS/N 17261763 N3020UKelly Ho-Montoya Insurance Group LLC · Wichita Falls, TXBuilt 1963 · S/N 17250620 N3021EAircraft Solutions LLC · Spokane, WABuilt 1978 · S/N 17271405 N3025UEddy Bruce A · Winfield, ALBuilt 1963 · S/N 17250625 N30278Barron Joseph M · Des Moines, IABuilt 1975 · S/N 17264133 N30285Galena City School District · Galena, AKBuilt 1974 · S/N 17264135 N302CFEastern Kentucky University · Richmond, KYBuilt 2002 · S/N 17281137 N302JAAviate LLC · Green Bay, WIBuilt 1977 · S/N 17269488 N302TXCareer Track 2 LLC · Wilmington, DEBuilt 2024 · S/N 172S13221 N3030EElon Aviation LLC · Burlington, NCBuilt 1978 · S/N 17271408 N3030UAll Around Inc · Ramseur, NCBuilt 1963 · S/N 17250630 N3031USandstrom David E · Anchorage, AKBuilt 1963 · S/N 17250631 N3034URay David W · Albuquerque, NMBuilt 1963 · S/N 17250634 N3035UFindley William R · Los Gatos, CABuilt 1963 · S/N 17250635 N30370Fellow Ship Aviation LLC · Monticello, GABuilt 1974 · S/N 17264136 N303EHNavigation Leasing LLC · Keizer, ORBuilt 2023 · S/N 172S13058 N303LKWestwind Aviation Inc · Bremerton, WABuilt 1973 · S/N 17262140 N303RHNavigation Leasing LLC · Kaizer, ORBuilt 2022 · S/N 172S12926 N303SFSnohomish Flying Service Inc · Snohomish, WABuilt 2025 · S/N 172S13478 N303STVolar Vii LLC · Edmond, OKBuilt 2012 · S/N 172S11242 N3041UMoser Paul J · Danville, PABuilt 1963 · S/N 17250641 N3045UAfterburner Aviation LLC · Lewes, DES/N 17250645 N30475Am Rhein Thomas R · Watsonville, CABuilt 1973 · S/N 17262791 N3048ECandace A Larned Enterprises Inc · Long Beach, CABuilt 1978 · S/N 17271417 N3049UHillberg Roger J · Crandon, WIBuilt 1963 · S/N 17250649 N304CPCivil Air Patrol · Maxwell Afb, ALBuilt 2020 · S/N 172S12511 N3050EDsi Limited Liability Corp · Blue Ridge, VABuilt 1978 · S/N 17271419 N30514S&S Aircraft Inc · Bennington, VTBuilt 1974 · S/N 17264141 N3051EBellingham Aviation Services LLC · Bellingham, WABuilt 1978 · S/N 17271420 N30522Colvin Buster · Big Cabin, OKBuilt 1974 · S/N 17264142

Back to AD 90-06-03 R1