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.

N2418ANation Linda S · Sanford, FLBuilt 1952 · S/N 22-784N2418KSterba Edward J · Ocala, FLBuilt 1979 · S/N 38-79A0622N2418MBallow Richard C · Valdez, AKBuilt 1947 · S/N 12-1652N2418RMann Steven · High Springs, FLBuilt 1969 · S/N 28-5617N2419ABoehlke Kevin P · New Baltimore, NYBuilt 1952 · S/N 22-786N2419PRegistration Pending · Lavale, MDRegistration pendingBuilt 1955 · S/N 22-3091N2419TN2419t Inc · Okeechobee, FLBuilt 1978 · S/N 38-78A0799N241ACTwob LLC · Eden Prairie, MNBuilt 1999 · S/N 1373-98N241ATAirline Transport Professionals Corp Of USA · Wilmington, DEBuilt 2000 · S/N 4496039N241AWStewart Lawrence D · Council Bluffs, IABuilt 2004 · S/N 5614N241BHughes Dustin G · Texarkana, TXBuilt 2016 · S/N 571702N241BDHanus David S · Mound, MNS/N 60477N241CFPalermo Michael S · Carter Lake, IABuilt 1957 · S/N 23-1160N241DWGaither William W Jr · Shallotte, NCS/N 634RGN241EPiedmont Aviation Leasing LLC · Monticello, GABuilt 1971 · S/N 17259889N241ERN241er LLC · Charlotte, NCBuilt 1992 · S/N 10120N241GWWheeler Gregory R · Spicewood, TXS/N 2248N241HCButcher Robert E · Friendswood, TXBuilt 2005 · S/N 81966N241HRHickey Timothy J · Montrose, IABuilt 2016 · S/N 808RN241JAHot Wings Aviation LLC · Indianapolis, INBuilt 2020 · S/N 28020011N241JESmedshammer Paul J · Petaluma, CABuilt 2001 · S/N 23868N241JPNate Nelsen LLC · Enterprise, ALBuilt 1963 · S/N 30-241N241KCChase Kenneth W · Anvik, AKS/N 22-4138N241KDReiter Kenneth L · Plano, TXBuilt 1998 · S/N 162N241KSCrane Kermit J · Topeka, KSBuilt 1973 · S/N 17262602N241LWDrouin William · Brookline, NHBuilt 1970 · S/N 700088N241MJMj Aero LLC · Mims, FLBuilt 1987 · S/N 1055N241NDSkyborne Airline Academy Inc · Vero Beach, FLBuilt 1999 · S/N 2842051N241PArnston Ranch Inc · Circle, MTBuilt 1992 · S/N 1214N241PCPlucinski David J · San Clemente, CABuilt 2005 · S/N 1385-2005N241PLAirplane And Drone Flight Instruction LLC · Orlando, FLBuilt 1985 · S/N 17276422N241RAGreat Escape Aviation Inc · Fort Lauderdale, FLBuilt 2002 · S/N 1322-2001N241RBJankowski Richard S · Shenandoah, TXBuilt 1997 · S/N 23274N241RGAmerican Patrols Inc · Midland, TXBuilt 1973 · S/N 17261916N241SPSeiler Scott S · Greer, SCBuilt 1983 · S/N TRENT 0002N241STBird Cory R · Tehachapi, CABuilt 2003 · S/N 001N241TJenison Lawrence E · Chelsea, MIBuilt 1953 · S/N 18-2355N241TTTherrell G Tony · Kannapolis, NCBuilt 1979 · S/N AA5B1113N241TWScotton Bradley D · Galena, AKBuilt 1996 · S/N TW96-002N241VUDynamic Aircraft Services LLC · Hurst, TXS/N 28-7515409N241VYShallbetter Joseph R · Marana, AZBuilt 1999 · S/N 1449N241WHMiller Michael A · Huffman, TXBuilt 1951 · S/N 18-816N241ZAlpha Tango Aircraft LLC · Wilmington, DEBuilt 2023 · S/N 2881610N24206Fike William E · Atlanta, GAS/N L-6709N24209Wright William F · Cleveland, OKBuilt 1939 · S/N L-6739N2420KNewhouse Hayden V · Fredericksburg, TXS/N 5147N2420LSasscer Michael Scott · Temecula, CABuilt 1994 · S/N 243N2420QBobby J Kirby Jr LLC · Hernando, FLBuilt 2004 · S/N 2894N24214Mckinney Brett A · Hackleburg, ALBuilt 1977 · S/N 15280154N2421PBoyko Matthew · Gilbert, AZBuilt 1955 · S/N 22-2792
Back to AD 90-04-06 R1