Registered aircraft · 68,369

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.

N2144WHansen Kenneth L · Kimballton, IABuilt 1979 · S/N 28-7916331 N21455Drewett Edward A · Many, LABuilt 1974 · S/N 17263950 N2145FSmith Jeffrey D · Hamilton, GAFirst renewal noticeBuilt 1972 · S/N AA5-0017 N2145MHanscom Afb Aero Club · Hanscom Afb, MAS/N 28R-7837069 N2145QErnstes William L · Greensburg, INBuilt 1974 · S/N 177RG0545 N2146MPeterson Scott W · Garfield, KSBuilt 1946 · S/N 20931 N2146QMcdonald Anthony Robert · Brookside, UTBuilt 1974 · S/N 177RG0546 N2146TBreitfelder Nicholas A · Durango, IABuilt 1971 · S/N 28-7125546 N2146XGalloway Robert L III · Cypress, TXBuilt 1997 · S/N 24-3413 N21471Gourley Adam C · La Porte, INBuilt 2000 · S/N 3426 N2147AHosmer Richard Alan · Cedartown, GABuilt 1952 · S/N 22-578 N2147GAviation Capital Management LLC · San Jose, CABuilt 1978 · S/N 28-7916178 N2147TSchavone Loren A · Fullerton, CABuilt 1971 · S/N 28-7125547 N2147WMeyer Ronnie G · Sidney, NEBuilt 1974 · S/N M-1520 N21481Houston Christopher T · Webster, NYBuilt 1978 · S/N 28-7916044 N21485Dipzinski Victor L · Clio, MIFirst renewal noticeBuilt 1974 · S/N 17263956 N21489D & S Aviation LLC · Spring, TXBuilt 1978 · S/N 28-7990050 N2148FRegistration Pending · Wilmington, DERegistration pendingBuilt 1978 · S/N 44-7995157 N2148QMorten Jesse L · Larimore, NDBuilt 1974 · S/N 177RG0548 N2148ZMalburg Phillip E · Holland, MIBuilt 1979 · S/N 28-7916378 N2149QRegistered aircraftBuilt 1974 · S/N 177RG0549 N214APikago LLC · Moreno Valley, CABuilt 1978 · S/N 17270830 N214AALewis University · Romeoville, ILS/N 28-4735 N214ACRicard Carter J · Albany, MNBuilt 2000 · S/N 1305-2000 N214BWKansas Farm & Ranch Inc · Seneca, KSBuilt 1994 · S/N 1202-94 N214CMeister Curtis E · Plover, WIBuilt 1998 · S/N 1430 N214CALester Don · Campton, NHBuilt 1974 · S/N 28R-7435281 N214CMKentucky Fly Boys Aviation LLC · Vine Grove, KYBuilt 1978 · S/N 372-78 N214DPRothhaar Paul M · Yorktown, VABuilt 1985 · S/N 38 N214DXDixon Craig M · La Grande, ORBuilt 2013 · S/N 91863 N214EDWoods Johnny I · Hendersonville, TNBuilt 1980 · S/N 44-8195007 N214ERLima-001 LLC · Muscatine, IAS/N 17263480 N214GPPietsch Warren A · Minot, NDBuilt 1994 · S/N Z1A-0016 N214GSStephens Mark · Cullman, ALBuilt 1972 · S/N 28-7205138 N214JC214 Mooney LLC · Boca Raton, FLBuilt 1978 · S/N 24-0706 N214JDMilngavie LLC · Plano, TXBuilt 2006 · S/N 20416 N214JNFox-1 Drafting & Design Inc · Eagan, MNBuilt 1966 · S/N 30-1130 N214LFHorsman Dewey D Jr · Crestview, FLBuilt 2004 · S/N 20-1031 N214LHRocky Mountain Flight Consultants LLC · Boulder, COBuilt 2005 · S/N 494-2005 N214LMHillsboro Aero Academy LLC · Hillsboro, ORBuilt 1978 · S/N 44-7995053 N214LPKrasa Paul W · Yorktown, VAFirst renewal noticeBuilt 1999 · S/N 214KR N214MKMargheritis Alex F Trustee · Saugus, CABuilt 2007 · S/N 81855 N214MMDunlap Lloyd A · Brighton, MIBuilt 1998 · S/N 335A-320-95 N214NLLescher Richard G · Monroe, WABuilt 2019 · S/N WR293S095 N214NYCabco Enterprises LLC · Springdale, ARS/N 899 N214PTNewkirk Peter C · Ellison Bay, WIBuilt 1990 · S/N 2039 N214RAJw Aero Holdings Inc · Canandaigua, NYBuilt 1976 · S/N 28-7690440 N214RBS And S 1165 Investments LLC · Wimberley, TXBuilt 1992 · S/N 2114 N214RRReiff Robert P · Fort Atkinson, WIBuilt 2008 · S/N 2646 N214SANeagle Jason S · Elizabethtown, KYS/N 28-7415482

Back to AD 90-04-06 R1