AD 90-04-06 R1

Registered aircraft · 68,377

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.

N5175SBlu Skye Distribution Inc · Mount Holly, NCBuilt 1970 · S/N 28-7105029N5175TMcclain Timothy J · Tucson, AZBuilt 1966 · S/N 147N51768Stocker Concrete Co · Gnadenhutten, OHBuilt 1978 · S/N 446N51769Arizona Skies Aviation LLC · Scottsdale, AZS/N 443N5176HBoyer Christopher A · Anchorage, AKBuilt 1948 · S/N 14-196N5176LMilliner Greg A · Kokomo, INBuilt 1967 · S/N 28-4462N5176NWhittock Tyson H · Anchorage, AKS/N 75-5379N5176RRight Rudder Flight Training LLC · La Verne, CABuilt 1979 · S/N 172RG0044N5176SNora Jet LLC · Granbury, TXS/N 28-7105030N5176TScott Judson M · Wasilla, AKBuilt 1967 · S/N 153N5176VVangorder Donna · Greenwood, ARS/N 172RG0459N51770Lrh Equipment LLC · Pendleton, ORS/N 445N51776Pennewell Ollie Lee · Hannibal, MOBuilt 1992 · S/N 1N51778Medical Evacuation Disaster Intervention Corps · Springdale, ARS/N 451-2N5177FPray Aviation Inc · Augusta, KSBuilt 1976 · S/N 28-7715096N5177HPomeroy Cattle Ranch LLC · Kalispell, MTBuilt 1975 · S/N 17265361N5177PLi Steven Y · Warren, NJBuilt 1958 · S/N 24-197N5177TJensen Larry F · Millington, MIBuilt 1967 · S/N 219N5177WBuffham Daniel L · Meridian, IDBuilt 1961 · S/N 28-212N5177XAdams John L · Carmi, ILBuilt 1969 · S/N 683N51787Holder Michael T · Whitesburg, GABuilt 1980 · S/N 1172N51788Rhoads Timothy C · Logan, NMBuilt 1978 · S/N 452-2N51789Breyer Charles A · Lewes, DEBuilt 1978 · S/N 454-2N5178AHale Mitchell D · Chugiak, AKBuilt 1962 · S/N 18-7483N5178HGage Scott M · Anchorage, AKS/N 14-200N5178LMinick And Son LLC · Beatrice, NEBuilt 1967 · S/N 28-4464N5178RHampton Flying Services LLC · Portsmouth, NHBuilt 1974 · S/N 17263395N5178WMahoney Christopher P · Quakertown, PABuilt 1961 · S/N 28-213N5178ZUnderwood Robert D Jr · Randolph, NYBuilt 1961 · S/N 22-8842N5179Bishop Kurt D · Findlay, OHBuilt 2007 · S/N 623N51790Tartock Russell L · Salisbury, NCBuilt 1979 · S/N AA5A-0850N51793Lindsey Richard A · Richmond, TXBuilt 1980 · S/N 17274347N5179HFlight Time Builders Inc · Memphis, TNBuilt 1975 · S/N 17265362N5179PHangar 17 LLC · Sheridan, WYBuilt 1958 · S/N 24-199N5179THiggs Kathleen A · Garden Plain, KSBuilt 1967 · S/N 139N5179VFairmont State University · Fairmont, WVBuilt 1980 · S/N 172RG0460N5179XKor Reese W · Piedmont, SDBuilt 1969 · S/N 189N517APa28 Aircraft LLC · Wilmington, DEBuilt 2014 · S/N 2843753N517AFAmeriflyers Of Texas Inc · Addison, TXBuilt 2021 · S/N 28020046N517BWWomer Blaine A · Hemet, CABuilt 2007 · S/N 2843652N517DLDelta Leema Aviation LLC · Moncks Corner, SCBuilt 1977 · S/N 17268965N517GSPtag Flight Service LLC · Vidalia, GABuilt 1996 · S/N 2996N517HWVogt Chancey · Becida, MNBuilt 2023 · S/N JA1308077N517JGollus Daniel T · Lockport, NYBuilt 1997 · S/N 22753N517JCProfessional Pilot Services · Appleton, WIBuilt 1971 · S/N 28-7125098N517JPJones Jerry K · Syracuse, UTBuilt 2007 · S/N 001N517LBuchenroth Steven L · Huntsville, OHFirst renewal noticeBuilt 1969 · S/N BP1N517RLAndrews Mimi M · Hilltop Lakes, TXBuilt 1996 · S/N 22626N517RSGraham Konner T · Pittsburg, TXBuilt 1998 · S/N 21117N517SCSpartan Education LLC · Tulsa, OKBuilt 2019 · S/N 2881264
Back to AD 90-04-06 R1