Registered aircraft · 68,359

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.

N1043KShadowens Jackie R · Sapulpa, OKBuilt 1954 · S/N 18-3919 N1043QRegistered aircraftBuilt 1977 · S/N 28R-7737025 N1043SAmerican Aviator LLC · Newark, DEBuilt 1977 · S/N 172-68679 N1043UClinton Arlys L · Fair Oaks, CABuilt 1946 · S/N 81 N1043XAustin Security Corp · Battleboro, NCBuilt 1975 · S/N 28R-7535224 N10446Schell Brothers II LLC · Rehoboth Beach, DEBuilt 1973 · S/N 172-62515 N1044FNottorf Eric W · Keller, TXBuilt 1995 · S/N 20046C N1044JNagasaka Bruce J · Weiser, IDBuilt 1973 · S/N 44 N1045Paragon Airplane Leasing Co · Fort Myers, FLBuilt 2024 · S/N 28020177 N1045ALange Bryan C · Harrison, NEBuilt 1951 · S/N 18-622 N1045BBigger Val J · Las Cruces, NMBuilt 2023 · S/N VBKD-1 N1045JFenn Matthew A · Liberal, KSBuilt 1996 · S/N 004 N1045LBernard Robert J · Millbury, MABuilt 1974 · S/N 638 N1045RKersting Thomas J · Volga, SDBuilt 1998 · S/N 21042C N1046BOglesby Jonathan D · Okmulgee, OKBuilt 1958 · S/N 1273 N1046ERisk Indemnification Professionals LLC · Boston, MABuilt 1977 · S/N 296-77 N1046XFarnham Aviation Services LLC · Ames, IABuilt 1975 · S/N 28-7525266 N1046ZAvery Robert K · Fort Worth, TXBuilt 1970 · S/N WLB-1 N10470Leary Dan P · Girdwood, AKBuilt 1951 · S/N 18-895 N10475Lissow William M · New Port Richey, FLBuilt 1967 · S/N 67-18368 N1047JFirst Flight Investments LLC · Bartow, FLBuilt 1973 · S/N 47 N1047MChristiansen Aviation LLC · Wilmington, DEBuilt 2007 · S/N 2842286 N1047NMccormick William R · Louisville, KYBuilt 1998 · S/N 28005C N1047VPoulter Thomas R · Chelsea, MIBuilt 1954 · S/N 18-3911 N1047XHuber Frank B · Maple Grove, MNBuilt 1977 · S/N AA1C-0050 N10481Marshburn Leroy D III · Kernersville, NCBuilt 1998 · S/N 21036C N1048AUnderdahl Kirby L · Hamilton, MTBuilt 1951 · S/N 18-626 N1048CPalmer Gretchen · Knoxville, TNBuilt 1976 · S/N 1153-76 N1048EPaul John R · Boise, IDBuilt 1977 · S/N 343-77 N1048FWard Anthony · Paige, TXBuilt 1997 · S/N 21013C N1048LSparrow Thomas E · Hawley, MNBuilt 1974 · S/N 641 N1048QTaf Aerial Services LLC · Corpus Christi, TXBuilt 1997 · S/N 21034C N1049JLoxley Jason C · Virginia, ILBuilt 1972 · S/N 49 N1049PLamal Thomas K · Fairbanks, AKBuilt 1957 · S/N 18-7816 N104AHickman John E Jr · Coronado, CABuilt 1947 · S/N C-104-212 N104AAMeridian Aircraft LLC · Wilmington, DEBuilt 2022 · S/N 2881573 N104ACRoss Stephen D · Greenfield, OHBuilt 1993 · S/N 363-93 N104AFNance David B · Quinton, VABuilt 1967 · S/N 17700238 N104BCHoudek Todd L · Roseburg, ORBuilt 1978 · S/N 7-0162 N104BLSpiva Brett · Knoxville, TNBuilt 1993 · S/N WJO-1 N104BVSea Horse Sportfishing LLC · Clinton, NCBuilt 1998 · S/N 405-98 N104CAMeggers Roger D · Baker, MTBuilt 1996 · S/N 1338 N104CCN104cc LLC · Fredericksburg, TXBuilt 2002 · S/N 9947CC N104CPN7293l LLC · Waxahachie, TXBuilt 1966 · S/N 30-1276 N104DMiller Charles H Jr · Cape Carteret, NCS/N A101 N104DFHayton Thomas M · Arcadia, OKBuilt 1975 · S/N 2098 N104DHPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 2881999 N104EDEdwards Aero Club · Edwards Afb, CABuilt 2000 · S/N 172S8484 N104EREmbry Riddle Aeronautical University · Daytona Beach, FLBuilt 2007 · S/N 2844135 N104FFPlane Fun Inc Tr Trustee · Snellville, GABuilt 1971 · S/N 145

Back to AD 90-04-06 R1