OpenAirDocs.org
AD 90-04-06 R1

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
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.

N208PFChristensen Todd S · Ririe, IDBuilt 2014 · S/N 6793N208PLLutz Paul Trustee · Seville, OHBuilt 2006 · S/N 24239N208RDChase Donaven Ray · Lake Elmo, MNBuilt 2003 · S/N 90178N208RGInland Northwest Aero LLC · Veradale, WABuilt 1966 · S/N 30-1152N2090PMartin Vernon W · Peoria Heights, ILS/N 23-678N2090QRawls Mike E · New Waverly, TXS/N 177RG0490N2090RRubright Erik M · Gladstone, MIBuilt 1969 · S/N 28-4975N2090VWater Sports Unlimited · Griffin, GABuilt 1979 · S/N 28-7990339N2090YKilbey Bryan E DBA · Defuniak Springs, FLS/N 177RG1106N20912Dart Gregory G · Mayville, NYBuilt 1976 · S/N 1N20915Shaw Kevin R · Canton, GAS/N GK-24N2091BRegistered aircraftBuilt 1978 · S/N 28-7990117N2091DRegistration Pending · Magnolia, TXRegistration pendingBuilt 1978 · S/N 28-7916141N2091ERebayr Inc · Mooresville, INBuilt 2002 · S/N S1837N2091QJohnson Earl V · Andalusia, ALBuilt 1974 · S/N 177RG0491N2091WDestefano Patrick · Adamsville, TNS/N 28R-7918076N20921Brigham David F · Elliottsville Twp, MEBuilt 1974 · S/N 17263869N2092AKimmons Anthony J · Quitman, TXBuilt 1978 · S/N 28-7916094N2092XAirx LLC · Warwick, RIBuilt 1979 · S/N 28-7916342N20930Currier Justin · Rixeyville, VABuilt 1939 · S/N GK-34N20932Registration Pending · Hammond, LARegistration pendingBuilt 1974 · S/N 17263872N20933Meacham Bruce E · Kansas City, KSS/N SA-233N20934Fly Skyhawk Llp · Galena, OHBuilt 1974 · S/N 17263874N2093MAir Cortright LLC · Boyne City, MIBuilt 1977 · S/N 28-7890228N2093SSkyline Aviation Inc · San Angelo, TXS/N S1910N2093TRollins Wesley F · Clover, SCBuilt 1970 · S/N 28R-7135038N20940Cirrus Flight Operations Inc · Minneapolis, MNBuilt 1974 · S/N 17263876N2094CAnson Air LLC · Sugar Land, TXBuilt 1978 · S/N 44-7995116N2094ROtt Rusty S · Sugar Grove, ILS/N 28-5459N2094TSuzuki Yoshinori · Ames, IABuilt 1970 · S/N 28R-7135039N20951Strevels Stephen M · Knoxville, TNBuilt 1974 · S/N 17263879N20954Hardin John M · Terrell, TXS/N 17263881N20958Ras Aviation LLC · Elyria, OHBuilt 1978 · S/N 28-7916020N2095KCalifornia In Nice Inc · San Jose, CAS/N 44-7995180N2095PForbes Richard L · Plano, TXBuilt 1956 · S/N 23-683N2095WOnnoh Fred · Oak Harbor, WABuilt 1979 · S/N 28R-7918077N20965Reich Aviation LLC · Loudon, TNBuilt 1974 · S/N 17263883N2096LMcfarland Bruce R · Newberry, FLBuilt 1978 · S/N 28-7916242N2096TDufur Casey L · Durant, OKBuilt 1971 · S/N 28R-7135041N2097NSidney Flying Club Inc · Sidney, OHBuilt 1979 · S/N 28-7916257N2097UNorris Barry D · Soquel, CABuilt 1979 · S/N 28-7916311N2098PRegistration Pending · Granger, IARegistration pendingS/N 23-686N2098TIsaacs Brandon · Homedale, IDBuilt 1971 · S/N 28R-7135043N2099Paragon Airplane Leasing Co · Fort Myers, FLBuilt 2024 · S/N 28020179N20992Sketo Aviation LLC · Bardstown, KYBuilt 1978 · S/N 28-7990030N2099CFrazier Jon A · Vista, CAS/N TD-276N2099QTice William · Lancaster, MABuilt 1974 · S/N 177RG0499N2099TArrowmark LLC · Schroeder, MNBuilt 1971 · S/N 28R-7135044N2099WInternational Air Services Inc Trustee · Carson City, NVBuilt 2000 · S/N 80438N209ARGeery James J · North Fort Myers, FLBuilt 2007 · S/N 71261
Back to AD 90-04-06 R1