Registered aircraft · 68,375

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-04-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:90-04-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:90-04-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:90-04-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:90-04-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:90-04-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.

N2739WKessler Henry L · San Gabriel, CABuilt 1966 · S/N 3344 N2739YEnnis Michael J · Eminence, MOBuilt 1958 · S/N TD-92 N273AAHammerschlag Richard S · Kamiah, IDBuilt 1959 · S/N TD-321 N273BGates Hiram P · Faribault, MNBuilt 1959 · S/N 131 N273CCRegenald Michaud Aviation LLC · Willows, CABuilt 2001 · S/N 9920CC N273EBNorth Country Aircraft Holdings LLC · Watertown, NYBuilt 1978 · S/N 17271018 N273EZMoore Monty R · Chancellor, ALBuilt 1981 · S/N 1994 N273JTros Corp · Wilmington, DEBuilt 2017 · S/N 1211 N273JFParrish Aviation Flight Academy LLC · Southlake, TXS/N 17261732 N273NDPurdue Aviation LLC · West Lafayette, INBuilt 2000 · S/N 28-42073 N273RLRegistered aircraftS/N AA1B-0273 N273SBAero White LLC · Wheat Ridge, COBuilt 1997 · S/N 1615 N273TKing Kalin J · Valdez, AKBuilt 1953 · S/N 18-2387 N273WYRobert D Henrichs LLC · Omaha, NEBuilt 2017 · S/N 3273 N2740MWroe Daniel C · Denton, MDS/N 12-1230 N2740RRegistration Pending · Wilmington, DERegistration pendingS/N 28R-35280 N2740VTheo Enterprises LLC · New Castle, DEBuilt 1975 · S/N 177RG0677 N2740WBakewell Keith · Independence, LABuilt 1966 · S/N 1038 N27412Johnson Gary I · Minot, NDBuilt 1940 · S/N 2054 N27414Cox Aaron D · Kalama, WABuilt 1940 · S/N 2056 N27416Adkins Robert · Vinton, OHBuilt 1940 · S/N 2058 N2741HEaa Aviation Foundation Inc · Oshkosh, WIBuilt 2014 · S/N 81180 N2741WEdison Robert J · Anchorage, AKBuilt 1966 · S/N 1039 N2741YCoelum LLC · Lake Mary, FLBuilt 1958 · S/N TD-94 N2742DLloyd Land Plane III LLC · Brighton, COBuilt 1952 · S/N 25284 N2742RCollinsworth Frederick W · Broken Arrow, OKBuilt 1969 · S/N 28R-35281 N2742WStraub R L DBA · Stanton, TXBuilt 1966 · S/N 1040 N27433Morgan Jeff P · Justin, TXBuilt 1940 · S/N 2075 N2743MKemp Dale W · Lampasas, TXBuilt 1946 · S/N 12-1229 N2744Morgan Jeff P · Justin, TXBuilt 2017 · S/N 2883 N27446Evans William Henry Jr · Gardendale, TXBuilt 1939 · S/N 2088 N2744JOvation Cwa LLC · Prairie Du Sac, WIBuilt 1979 · S/N 17273644 N2744VHerrenkohl Robert D · Bay Point, CAS/N 3346 N27452Cook Franklin · Baraboo, WIBuilt 1940 · S/N 2094 N2745MNfh Aviation LLC · Pikeville, KYBuilt 1999 · S/N 17280586 N2745PColgan Paulette · Tucson, AZBuilt 2010 · S/N 90142 N2745ZKlabunde Andrew G · Menasha, WIBuilt 1978 · S/N 357-78 N27461Topp William J · Marion, KYS/N 2103 N27468Smith Carol J Executrix · Gilbertsville, KYBuilt 1940 · S/N 2110 N2746CChen Mark · Plano, TXBuilt 1998 · S/N 17280587 N2746MStonecipher Wayne H · Yamhill, ORBuilt 1947 · S/N 12-1233 N2746PParish Brandon · Mendon, UTBuilt 1955 · S/N 22-3053 N2746YDavenport Jimmy J · Hayesville, NCBuilt 1958 · S/N TD-104 N2747GVogt Mark Allen · San Diego, CABuilt 1967 · S/N 143 N2747MGuy Vaughn Zindel III · Eden, UTBuilt 1946 · S/N 12-1234 N2747PSvendsen Jon A · Wasilla, AKBuilt 1955 · S/N 22-3054 N2747YJennflight Inc · Chagrin Falls, OHS/N TD-96 N27487Van Winkle Randy M · Van Buren, MOS/N 2129 N27488Bradford Murvin L · Hensley, ARS/N 2130 N2748GNoe Aviation LLC · Vinton, IAS/N 152

Back to AD 90-04-06 R1