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.

N13923Timoszyk James S · Wayne, MIBuilt 1974 · S/N 17263039N13925Lindsay John S · Freeport, PABuilt 1971 · S/N 18-8973N13927Zerck Joseph W · Anchorage, AKBuilt 1972 · S/N 18-8977N1392AHerrig Daniel C · King Salmon, AKBuilt 1951 · S/N 18-1228N1392WSale Reported · Lakeland, FLSale reportedBuilt 1964 · S/N 2670N13931Mahoney Edmund Mont · Anchorage, AKBuilt 1972 · S/N 18-8978N13937Rafter J Aviation LLC · Moab, UTS/N 18-8979N13938Seattle Offshore Dmi Inc · Bothell, WAS/N 17263041N13939Diessner Daniel J · New Smyrna Beach, FLBuilt 1976 · S/N 17702477N1393CHayden Daniel · North Pole, AKS/N 20-980N1393EMossler Jonathan E · Edgewater, FLBuilt 1978 · S/N 17270983N1393PSeymour Lori L · Woodstock, GAS/N 23-445N1393USelim Shahir P · Hollywood, FLBuilt 1976 · S/N 17267064N1393VWayne Brett M · Saint George, UTS/N HAY 0001N13941Wings Over Texas Holdings LLC · Denton, TXBuilt 1974 · S/N 17263044N13942Rohrer Mary · Fredericksburg, TXBuilt 1974 · S/N 17263045N13943Tell Christopher A · Colville, WAS/N 17263046N13944Ripp Ted · Pulaski, TNBuilt 1974 · S/N 17263047N13946Air Capital Aviators Club · Wichita, KSBuilt 1974 · S/N 17263048N1394JFendi Aviation LLC · Petal, MSS/N 394N1394RRoss Bill · Meridian, MSBuilt 1952 · S/N 18-1983N1394WLuniewicz Morgan · Walnutport, PAFirst renewal noticeS/N 2672N1394YOjendyk Mark R · Newcastle, WABuilt 1953 · S/N 18-3357N13951Black Timber Aviation LLC · Rifle, COBuilt 1972 · S/N 18-8981N1395EHendricks Paul · Yellville, ARBuilt 1978 · S/N 17270984N1395FMoquin Christopher · Chicago, ILS/N 578 38 8392N1395JWard Brian S · Long Beach, CABuilt 1975 · S/N 395N1395RKing Rodney R · Lucedale, MSBuilt 1975 · S/N AA5-0795N1395TLegacy Aerospace Industries LLC · Miami, FLS/N 28R-7235277N1395UBentley Robert H · Lockport, ILBuilt 1976 · S/N 17267066N1395WRienstra Andrew P · South Lyon, MIBuilt 1964 · S/N 2673N13960John Mark Air Repair LLC · Chugiak, AKBuilt 1972 · S/N 18-8984N1396RHodges John J · Cleburne, TXBuilt 1975 · S/N AA5-0796N1396WD & J Solutions Inc · Nokesville, VABuilt 1964 · S/N 2674N13973Rs Specialties LLC · Anchorage, AKBuilt 1972 · S/N 18-8985N1397CDerr Rodney W · Frackville, PAS/N 22-1154N1397URock Solid Aviation LLC · Lake Charles, LABuilt 1976 · S/N 17267068N1397WMorris Michael E · Las Vegas, NVBuilt 1964 · S/N 2675N1398CBennett Eric · Warsaw, INBuilt 1977 · S/N 17702720N1398EMichael Elan · Encino, CABuilt 1978 · S/N 17270985N1398HMiller Debra L · Anchorage, AKS/N 15AC-449N1398JPrivedenynk Sergey · Springfield, MABuilt 1975 · S/N 398N1398PWolbert Valerie M · Canton, GABuilt 1956 · S/N 23-449N1398RHopland Steven R · Johnson City, TNBuilt 1975 · S/N AA5-0798N1399CShankster Thomas G · Aurora, COBuilt 1953 · S/N 22-1150N1399TLauff Samuel Jr · Ocala, FLBuilt 1972 · S/N 28R-7235278N1399UOc 172 Group LLC · Costa Mesa, CAFirst renewal noticeBuilt 1976 · S/N 17267070N139AAMeloan Andrew Newton · St Helena Is, SCBuilt 2000 · S/N 04980085N139ACDavis Mark A · Lubbock, TXBuilt 1992 · S/N 686-92N139AGSchool Board Of Seminole Co Florida · Sanford, FLFirst renewal noticeBuilt 1981 · S/N 0131
Back to AD 90-04-06 R1