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.

N300LDJones Clayton S · Kalispell, MTBuilt 1968 · S/N 1404 N300LMBarnstormer Holdings LLC · Palm City, FLBuilt 1942 · S/N 75-2855 N300LYEwald Robert H · Red Lodge, MTBuilt 1943 · S/N 75-4415 N300MConway Frank P · Sneads Ferry, NCBuilt 1978 · S/N 24-0630 N300MDHeywood Bruce N · Panguitch, UTS/N 400 N300MLStoneman Thomas K · Friendswood, TXBuilt 2000 · S/N GA1113233 N300MMHamblin Kenneth · Stanton, TNBuilt 1965 · S/N 30-851 N300NBMcilrath Thor · Arlington, WABuilt 1980 · S/N 1100981 N300PAmerican Aviator LLC · Arlington, TXBuilt 1976 · S/N 177RG0989 N300PAAero Maintenance Inc · Vancouver, WABuilt 1974 · S/N 28R-7435206 N300PSRight Coast Ventures LLC · Royse City, TXBuilt 1968 · S/N 17257501 N300QRPdq Flight Inc · Garden City, NYBuilt 1979 · S/N 17273539 N300REMoreau Leo B · Wasilla, AKBuilt 1965 · S/N 30-841 N300RFRivers Robert A · Oxford, NCBuilt 1983 · S/N BJ-2 N300RGRein Richard C · St George, UTS/N AA5A-0159 N300RVHall Farms Inc · Garfield, KSBuilt 2003 · S/N 24740 N300SBGustafson Cody A · Corvallis, ORBuilt 1993 · S/N 001 N300TOlsen M Lindsay · Prairie Village, KSBuilt 1953 · S/N 18-2414 N300TFSouthern Cross Aviation Inc · Wilmington, DEBuilt 1978 · S/N 1001 N300UBoard Of Regents Of The Univeristy Of Oklahoma · Norman, OKBuilt 2025 · S/N 28020226 N300VTCarroll James K · Klamath Falls, ORBuilt 1999 · S/N DM0276 N300WSOdyssey Aviation LLC · Raleigh, NCBuilt 1992 · S/N 687-92 N300WYChupka William J · Riverton, WYBuilt 1965 · S/N 28-21280 N30101Sunrise Aviation Inc · Ormond Beach, FLBuilt 1978 · S/N 44-7995069 N3010ELenzen Richard D Dr · Antioch, ILBuilt 1978 · S/N 28-7916167 N3010MAtlseimer John C · Ione, CABuilt 1947 · S/N 12-1709 N3010WSunwest Aviation Inc · Santa Ynez, CABuilt 1995 · S/N 28-43016 N3010ZClemente Matthew J · Troy, NYBuilt 1959 · S/N 22-6961 N30112Leonard Kevin J · Wagner, SDBuilt 1968 · S/N 17701066 N30114International Aviation Group LLC · Lake Wales, FLBuilt 1978 · S/N 28-7916076 N30116Registration Pending · Benson, AZRegistration pendingBuilt 1968 · S/N 17701068 N30117D & S Aviation LLC · Spring, TXBuilt 1978 · S/N 28-7916077 N3011FGordon Air Services Inc · Miami, FLBuilt 1974 · S/N 17263447 N3011WHall Larry C · Decatur, ALBuilt 1996 · S/N 28-43065 N3011ZBoe Arvid J · Langdon, NDBuilt 1979 · S/N 28-7916393 N30121Jokerst Kenneth · St Louis, MOBuilt 1968 · S/N 601 N30123Devore Walter H · Texarkana, TXBuilt 1966 · S/N 1 N30126Pilots Choice Aviation Equipment Leasing Co · Georgetown, TXBuilt 1978 · S/N 28-7990084 N30128Mizani Air LLC · San Antonio, TXBuilt 1968 · S/N 17701069 N3012ABottoms Engineering & Service Inc · Frankfort, KYBuilt 1978 · S/N 28-7990112 N3012DArias Herman R · Waco, GAS/N 28-7916154 N3012EDamschroder Rex A · Fremont, OHBuilt 1978 · S/N 17271402 N3012MWatkins Brian D · Vancouver, WAS/N 12-1571 N3012ZChase 13 LLC · Wilmington, DEBuilt 1959 · S/N 22-6963 N30133Ts Fliers LLC · Mount Pleasant, MIBuilt 1968 · S/N 17701070 N30139Heinitz Bradford C · Arlington, WAS/N 17701074 N3013DMcclary Doug T · South Lyon, MIBuilt 1978 · S/N 28-7990170 N3013MDavis David N · Haskell, OKBuilt 1947 · S/N 12-1573 N3013ZZakos Dean R · Middleton, WIBuilt 1979 · S/N 28-7916395 N30142Marshman Robert M · Murfreesboro, TNBuilt 1968 · S/N 17701075

Back to AD 90-04-06 R1