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.

N1355JHlatshwayo Mbusi S · Alhambra, CABuilt 1975 · S/N 355N1355RFly Guys LLC · Arcata, CABuilt 1975 · S/N AA5-0755N1355WBloch Matthew William · Marquette, MIS/N 2636N13564Cain James W · Big Rapids, MIBuilt 1976 · S/N 17702437N13565Williams Jim J · Jackson, NJBuilt 1976 · S/N 17702438N1356FJprg Aviation Inc · Orlando, FLS/N 17272999N1356QRouth Frank D · Marion, NCBuilt 1982 · S/N JAR-1N1356UN1356u LLC · Wilmington, DEBuilt 1976 · S/N 17267027N1356WMeachum Larry · Beaumont, TXFirst renewal noticeS/N RAP-02N1356YBoggs John D · Duncan, OKS/N B-1N13573Davis Flying Services LLC · Gaithersburg, MDBuilt 1973 · S/N 17262856N1357ACarson Cubs LLC · Yelm, WABuilt 1951 · S/N 18-1181N1357CSummit Concepts Inc · Wilmington, DES/N 17702710N1357NGibbs Robert I · Ravenswood, WVBuilt 1943 · S/N 75-5423N1357UHarte Ryan D · Lone Star, TXBuilt 1976 · S/N 17267028N13586Oreilly Thomas P · Oscoda, MIBuilt 1973 · S/N 17262860N13587Nasairs Flying Club · Strongsville, OHBuilt 1973 · S/N 17262861N1358ASchroeder Herbert P · Eagle River, AKBuilt 1951 · S/N 18-1184N1358TMizera David · Hillsboro, ILBuilt 1972 · S/N 28-7225481N1358UWaddill Paula J · Puryear, TNBuilt 1976 · S/N 17267029N1358WDavis Charles S · Fairfield Bay, ARBuilt 1964 · S/N 2722N13590Habibelahian Hamid Reza · Jefferson, TXS/N 17262863N13593Absolute Altitude LLC · Murrieta, CABuilt 1973 · S/N 17262866N13594Chambers Quentin S · Bellingham, WABuilt 1973 · S/N 17262867N13596Gary Rollin F · Dallas, TXS/N 17702440N13597Heeter Michael · Bloomington, MNBuilt 1976 · S/N 17702441N1359CCromer Aubrey E · Anderson, SCBuilt 1977 · S/N 17702711N1359REllingson Jason J · Edina, MNBuilt 1975 · S/N AA5-0759N1359TNahir Ehud · Woodland Hills, CABuilt 1972 · S/N 28-7205288N1359UHokie Flying Club Inc · Christiansburg, VABuilt 1976 · S/N 17267030N1359WKroll Richard · Laguna Niguel, CABuilt 1963 · S/N 2640N135EG305 Aviation Group Inc · Miami, FLS/N 28-8290170N135EKEc Aviation Group Corp · Ponte Vedra, FLS/N 902N135GAMicke Thomas B · Mansfield, MABuilt 1992 · S/N 2102N135JCNelson Bradley L · Portland, ORBuilt 1967 · S/N 670337N135JDMorris Edward J · Bay City, MIBuilt 1988 · S/N 106N135KAcord Aviation Co L L C · Chandler, OKBuilt 1967 · S/N TD-691N135KAMccarthy Kiva A · Wasilla, AKBuilt 1973 · S/N 18-7309021N135KSBunde Konstantine E · Goldendale, WABuilt 1956 · S/N 18-4061N135LUS Department Of The Interior · Boise, IDBuilt 2016 · S/N CC18-0079N135PZGotschall John F · Silverdale, WABuilt 1995 · S/N 1N135RBWalter Caleb · Buffalo, WYS/N 18-3630N135SSpencer William D · Martinsville, VAS/N 27N135SBEricson Steven P · Lancaster, CAS/N 1N135TMMowbray Jerry H · Reno, NVBuilt 2001 · S/N 1384-2001N135UInter American University Of Puerto Rico · Bayamon, PRBuilt 1997 · S/N 4496015N135VUPerformance Aircraft Sales Inc · Lincoln, NEBuilt 2003 · S/N 17281192N135WAHardin Melissa K · Terrell, TXBuilt 1979 · S/N 15283655N135WKGerlach Robert · Talkeetna, AKBuilt 1952 · S/N 182160N135WMTownsend Richard A · Wasilla, AKBuilt 1954 · S/N 18-3599
Back to AD 90-04-06 R1