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.

N3625TBlade Runners Chopper LLC · Sunbury, OHBuilt 1989 · S/N S1396 N36266Barney Bill L · Fairbanks, AKBuilt 1973 · S/N 560-73 N36267Ashcraft Keirsten · Longview, TXS/N 269-73 N3626BBarney Thomas E · Cresco, PABuilt 1985 · S/N S1196 N3626XJameson John M · Enid, OKBuilt 1969 · S/N 354 N36276Gronning Skyler · Westby, WIBuilt 1978 · S/N 28-7816624 N36278Wolcott Kent E · Colorado Springs, COBuilt 1944 · S/N 6350 N3627EJmch Flight LLC · Henderson, NVBuilt 1978 · S/N 17271610 N3627XMonagas Jose · Lehigh Acres, FLBuilt 1969 · S/N 355 N3627ZHousel Thomas J · Pebble Beach, CABuilt 1960 · S/N 22-7519 N36281Hedgehog Management LLC · Salem, OHBuilt 1978 · S/N 28-7890503 N36282Beverly Flight Center LLC · Danvers, MABuilt 1978 · S/N 28R-7837271 N36285Schreiber Ray R · New Palestine, INBuilt 1973 · S/N 964-73 N36288Monke David W · Fontanelle, NEBuilt 1973 · S/N 563-73 N3628HCutilo Jonathan C · Pottstown, PABuilt 1978 · S/N 20-1253 N3628QJ&B Toys Inc · Wilmington, DEBuilt 1967 · S/N MA-213 N36299Wiebe James R · Valley Center, KSBuilt 2016 · S/N 20863 N3629HHolley Victor R · Seneca, SCBuilt 1978 · S/N 20-1254 N3629MPazsint Joseph J · Wasilla, AKBuilt 1947 · S/N 12-2476 N3629RJohns Brian A · Efland, NCBuilt 1970 · S/N 28-5725 N362ARRutz Andrew J · Cazenovia, NYS/N 6379010 N362BLLabelle Brendan · Huntington, NYBuilt 1978 · S/N 17270478 N362CAChoice Aviation LLC · Hamilton, MTBuilt 1970 · S/N 17258976 N362CTErvin Thomas D · Killbuck Township, OHBuilt 2005 · S/N 60362 N362ESIasco Flight Training Inc · Redding, CABuilt 1997 · S/N 17280013 N362HZSpencer Rimmel Lee · Haskell, OKBuilt 2022 · S/N 362 N362JDTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1998 · S/N 2843158 N362MBAcme Aircraft Flying Club LLC · Kalispell, MTBuilt 2009 · S/N 70577 N362MKNorth Star Aviation Inc · Mankato, MNBuilt 2022 · S/N 2881589 N362NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2023 · S/N 2881656 N362RBMillsap Christopher J · Castro Valley, CABuilt 1975 · S/N 123288117 N362SPEastern Cincinnati Aviation Inc · Batavia, OHBuilt 2001 · S/N 172S8779 N362WSBarrett Neville P E Trustee · Miami, FLS/N LNC571360WS92 N36304Capital Aviation II LLC · Bethesda, MDBuilt 1978 · S/N 28-7890504 N3630NSalvesen William · Clermont, NJBuilt 1967 · S/N 680018 N3630QStar Aviation LLC · Mauston, WIBuilt 1967 · S/N MA-225 N3630RLachance John A · Thompson, CTBuilt 1971 · S/N 28-7125375 N3631EMudcat Construction Inc · Beattyville, KYBuilt 1978 · S/N 17271611 N3631PRoss Donald M · Fallbrook, CABuilt 1956 · S/N 22-3726 N3631XLee Brent · Cumming, GABuilt 1969 · S/N 359 N3632EHigh Exposure Inc · Wilmington, DEFirst renewal noticeBuilt 1978 · S/N 17271612 N36335Simmons Darren · Diamondhead, MSBuilt 1973 · S/N 271-73 N36336Mierzejewski Karl · State College, PABuilt 1973 · S/N 965-73 N36337Boling Derek · Paragould, ARBuilt 1973 · S/N 107-73 N3633AMartin Michael O · Frisco, TXBuilt 1954 · S/N 22-1891 N3633MBrekhus Rickey G · Kenmare, NDBuilt 1947 · S/N 12-2521 N3633NPerotti Camille C · Carolina Beach, NCBuilt 1967 · S/N 680019 N3633RGrammar Adrian Gates · Geneva, NYBuilt 1970 · S/N 28-5728 N36349Richardson Thomas R · Valleyford, WABuilt 1973 · S/N 967-73 N3634RRatkovich Stephen · Prospect Heights, ILBuilt 1971 · S/N 28-7125140

Back to AD 90-04-06 R1