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.

N8132YJessen Eric Carl · La Luz, NMBuilt 1966 · S/N 30-1244N81337Bandito Aviation LLC · Naples, FLBuilt 1995 · S/N AS200N8133CCarter Marl · Coburg, ORBuilt 1975 · S/N 28-7690104N8133ELane Community College · Eugene, ORBuilt 1980 · S/N 28-8016167N8133JWarrior Aviation LLC · Stanford, KYBuilt 1979 · S/N 28-8016170N8133YLeaders Bob O · Clear Lake, MNBuilt 1966 · S/N 30-1245N81344November 46a Leasing Inc · St Augustine, FLBuilt 1980 · S/N 28-8016169N81345Bailey Roger I · Silverdale, WABuilt 1977 · S/N AA5B0502N81347Tusha Kenneth R · Yankton, SDBuilt 1977 · S/N AA5B0503N8134CCentral Virginia Aviation Inc · North Dinwiddie, VAS/N 22-2296N8134DDewolf Logan J · Eagle River, AKS/N 22-4778N8134WBrilliant Holdings LLC · Winfield, MOS/N 28-2245N81354Figueroa Lionel · Sacramento, CAFirst renewal noticeBuilt 1977 · S/N AA5B0506N81357Cascade Aircraft LLC · Eugene, ORBuilt 1977 · S/N AA5B0507N81359Tuckahoe Aviation LLC · Tequesta, FLBuilt 1977 · S/N AA5B0508N8135CCoverdale Aviation LLC · Ellendale, DEBuilt 1979 · S/N 28-8016173N8135DDickerson Joseph Ra · Anchorage, AKBuilt 1957 · S/N 22-5626N8135GMiloud Chadd K · Fort Worth, TXBuilt 1979 · S/N 28-8016175N8135JWilbur-Ellis Co · Salinas, CABuilt 1972 · S/N 25060N8135LTri County Rentals And Sales Inc · Bell, FLS/N 580847N8135PStein David J · New Port Richey, FLBuilt 1979 · S/N 28-8016176N8135WWoodrum Alan D · Danville, ILBuilt 1965 · S/N 28-2246N81360Ayer Edward Wayne · Warner Robins, GABuilt 1977 · S/N AA5B0509N81364F2f LLC · Milford, CTBuilt 1977 · S/N AA5B0510N81367Johnson David M · Baltimore, MDBuilt 1977 · S/N AA5B0512N81368Steinruck Thomas III · Temple Terrace, FLBuilt 1977 · S/N AA5B0513N8136JRiti Inc · Jackson, TNBuilt 1979 · S/N 28-8090173N8136QVenture West LLC · Mesa, AZBuilt 1979 · S/N 28-8090174N8136WNajjar Craig S · Norwood, MABuilt 1965 · S/N 28-2249N81376Spackman Timothy Oliver · Houston, TXBuilt 1977 · S/N AA5B0515N81377Mcgaughy Ellis H · Eastover, NCBuilt 1977 · S/N AA5B0516N8137QUnited States Air Force · Hanscom Afb, MABuilt 1979 · S/N 28-8016179N8137UMiloud Chadd K · Fort Worth, TXBuilt 1979 · S/N 28-8016181N8137YSale Reported · Chisago City, MNSale reportedBuilt 1966 · S/N 30-1248N81382Schear Brian · Costa Mesa, CABuilt 1977 · S/N AA5B0519N81384Royals Navy LLC · Lewes, DEBuilt 1977 · S/N AA5B0523N81388Byrne Jan · Greenwood, INBuilt 1977 · S/N AA5B0524N8138DAir Group Inc · Marietta, GABuilt 1958 · S/N 22-5629N8138EMorris John A · Phoenix, AZBuilt 1999 · S/N 146N8138HAccelerated Aviation Instruction LLC · Owatonna, MNBuilt 1979 · S/N 28-8090178N8138LN8138l LLC · Metairie, LABuilt 1978 · S/N A1520828N8138WSky Air Inc · Cedar Rapids, IABuilt 1965 · S/N 28-2251N8138YBelmont Aviation LLC · Port Saint Lucie, FLBuilt 1979 · S/N 28-8090180N81391Gibney Frank A · Colchester, VTS/N 1102N81398Mast Henry V · Dayton, TXBuilt 1995 · S/N 22327N8139EElliott Carl J · Fort Worth, TXRegistration revokedBuilt 1959 · S/N 1410N8139NPerucca Douglas E · Wasilla, AKBuilt 1998 · S/N 3650N8139WHigh Five Flight Inc · Dawson, NEBuilt 1965 · S/N 28-2252N8139YBuchanan Jason A · Meridian, IDBuilt 1966 · S/N 30-1250N813BSutter Timothy C · Glennallen, AKS/N 6743
Back to AD 90-04-06 R1