OpenAirDocs.org
AD 90-04-06 R1

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

N31845Walls Sales LLC · Poplar Bluff, MOBuilt 1940 · S/N L-11380N31851Sellix Eric R · Lehighton, PABuilt 1940 · S/N L11450N3185MEva Tn LLC · Wilmington, DEBuilt 1947 · S/N 12-1866N3186Shettel Jay E II · Carlisle, PABuilt 1970 · S/N HH-1N31863Dell Air Co LLC · Paterson, NJBuilt 1978 · S/N 28-7890482N31868Yarger Dylan C · Anchorage, AKBuilt 1995 · S/N 19040CN3186MKuenzli Casey I · Nyssa, ORS/N 12-2013N3187MZimmerman Kyle R · Gilbert, AZBuilt 1947 · S/N 12-2014N3187PAir Over Ground LLC · Helena, MTS/N 23-1124N3187QJuliet Whiskey Aviation LLC · Gilbert, AZBuilt 1977 · S/N 28-7790441N3187SWinberg Tanner · Dorchester, NES/N 14070CN3188MBirch Jerome I Trustee · Anchorage, AKBuilt 1947 · S/N 12-1867N3188TRucinski Edward A · Climax, NCS/N 17700488N3189QBoll Weevil Flyers LLC · Reedville, VABuilt 1977 · S/N 28R-7737049N318ACAughenbaugh Alan M · Iroquois, SDBuilt 2000 · S/N 1298-2000N318AWWeinberg Andrew B · Meadow Vista, CABuilt 2019 · S/N 003N318EBEdwards Robert G · Madison, WIBuilt 2016 · S/N 81878N318FCMendoza Jeremy · Honolulu, HIS/N 28-25156N318JRFlywell Aviation LLC · Bowling Green, KYBuilt 2006 · S/N 1013-2006N318MAHigh Plains Aviation LLC · Nara Visa, NMBuilt 2001 · S/N 2178N318MBHenderson Michael E · Edmonds, WABuilt 2006 · S/N 5661N318PABird Acquisition LLC · Phoenix, AZBuilt 2002 · S/N 4496134N318PWN318pw LLC · New Canaan, CTBuilt 1973 · S/N 17262171N318RALouden Bruce H · Kalispell, MTFirst renewal noticeBuilt 1977 · S/N 13048N318RCLafrance Lon H · Rocky Mount, MOBuilt 1977 · S/N 17269183N318TMOgino Todd T · Barrington, ILBuilt 2009 · S/N 71942N318VFShramek Troy A · Bossier City, LABuilt 1973 · S/N 17702008N318WMQuinn James Yancie · Farmers Branch, TXBuilt 2001 · S/N 1327N31900Woodward Joseph A Jr · Wshngtn Xing, PABuilt 1978 · S/N 28-7816592N31905Weishuhn Aviation LLC · Farwell, MIBuilt 1978 · S/N 28-7890484N3190BThomas Peter G Trustee · Reno, NVBuilt 1953 · S/N 25432N3190MHart David E · Jackson, GABuilt 1947 · S/N 12-2008N31918Registration Pending · Lamar, ARRegistration pendingBuilt 1941 · S/N LB11971N3191MHerder John P · Phoenix, AZBuilt 1947 · S/N 12-2007N3191PStone Clifford F Jr · Corning, CABuilt 1957 · S/N 23-1129N31923Metro Aicraft Co · Bloomington, MNBuilt 1978 · S/N 28-7816597N31926Van Cura Don · Chicago, ILBuilt 1978 · S/N 28-7890486N3192THawley James W · Waddell, AZBuilt 1967 · S/N 17700492N31931Evans Cameron Steven · Union Grove, WIBuilt 1941 · S/N L-12091N31939Holt Thomas S · Layton, UTBuilt 2018 · S/N 1212N3194PGalindo Don R Jr · Walnut Grove, CABuilt 1980 · S/N 18-8009042N3195Gorham Luke E · Wichita Falls, TXBuilt 2001 · S/N 4009N31950Kasparie Ronald · Quincy, ILBuilt 1978 · S/N 28R-7837259N3195ZMcgrady Chadwick Paxton · Glade Park, COBuilt 1959 · S/N 18-7191N31963Shepard Logan K · Sultan, WAS/N L12461N31969Chandelle Flying Club Inc. · Austin, TXBuilt 1978 · S/N 28-7890488N3196TNicholson Perry R · Merlin, ORBuilt 1968 · S/N 17700496N31970Benefield John H Jr · Cedartown, GABuilt 1978 · S/N 28R-7837260N3197TMundle Jeffrey A · Ashland, ORBuilt 1967 · S/N 17700497N3197ZSlayden Steven M · Rhome, TXBuilt 1959 · S/N 18-7195
Back to AD 90-04-06 R1