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.

N9219VChen Brian K · Bakersfield, CABuilt 1969 · S/N 690047N921AARegistration Pending · Deland, FLRegistration pendingBuilt 1973 · S/N 17261752N921BLLewis Bertrand V · Glendale, AZBuilt 1964 · S/N 30558N921DCCarlson Donald A III · Lexington, TNBuilt 1975 · S/N AA5B-0039N921JKShackleford Wayne D · Riverside, CABuilt 1982 · S/N 921-80N921KCRocket City Helicopters LLC · Brownsboro, ALBuilt 1992 · S/N 2180N921LCCrum Robert W · Lake Havasu City, AZBuilt 1969 · S/N 28-25939N921NDUniversity Of North Dakota · Grand Forks, NDBuilt 2025 · S/N 2881885N921PABird Acquisition LLC · Phoenix, AZBuilt 1999 · S/N 2843268N921PCProppe Karl H · Needham, MABuilt 1992 · S/N 1809058N921RCCall Raymond T · Batesville, INBuilt 2016 · S/N 463N921RSSpry Mark W · Elkmont, ALBuilt 2020 · S/N 221MSN921SJDavis Brandon Grey · Huntsville, ALBuilt 2010 · S/N 20208N921TAAtp Aircraft 4 LLC · Wilmington, DEBuilt 1997 · S/N 17280244N921TCBell Charles S · Fort Payne, ALS/N 23695N921UTumbleweed Leasing Co Inc · Salt Lake City, UTBuilt 2004 · S/N 3566N921WC7 Corp · Orlando, FLBuilt 1964 · S/N 2878N921WJJones Wesley C · Yuba City, CABuilt 2016 · S/N 90822N921XPLengler Aviation LLC · Fort Myers, FLBuilt 1962 · S/N 1905N922Tjk Enterprises LLC · Helena, MTBuilt 1977 · S/N 965-77N9220DEllis Harvey Airport Inc · Guthrie, OKS/N 22-6280N9220MBeaty David · Santa Fe, NMBuilt 1966 · S/N 1181N9220SWard Jessica · Southport, NCBuilt 1975 · S/N MC-380N9221DOrmond Aircraft Leasing & Management Inc · Ormond Beach, FLBuilt 1988 · S/N 2841030N9221JJgms Rose LLC · Stamford, CTBuilt 1966 · S/N 28-3291N9222DMatthews David C · Fairbanks, AKBuilt 1958 · S/N 22-6282N9222LTyler Timothy C · Wyoming, OHS/N AA1A-0122N9222SSvendsen James · Center Moriches, NYBuilt 1975 · S/N M-1718N9222VSoco Scuba LLC · Austin, TXS/N 690052N92236Garfoot William K · Verona, WIBuilt 1982 · S/N 0233N9223FMckeeman Kevin · Abilene, KSS/N 14039CN9223HHallock Robert C III · Sag Harbor, NYBuilt 1975 · S/N 17266024N9223JRudo Mark R · Milton, DEBuilt 1966 · S/N 28-3293N9223LHogan Fredrick C · Oviedo, FLBuilt 1971 · S/N AA1A-0123N9223VQuick Janice L · Wrightwood, CABuilt 1969 · S/N 690060N92247World Class Aviation Ltd · Bellefontaine, OHS/N 14022CN9224JJackson Jonathan · Siloam Springs, ARBuilt 1966 · S/N 28-3294N9224LAnalytical Technologies Inc · Miami, FLBuilt 1971 · S/N AA1A-0124N9224VBevington Carl R · Middle Point, OHBuilt 1969 · S/N 690053N92255Kloker Daniel E · Owasso, OKBuilt 1973 · S/N 17261554N92258Mendez Leonel Jr · Corpus Christi, TXBuilt 1978 · S/N 38-79A0014N9225CMeriden Aviation Center LLC · Meriden, CTBuilt 1978 · S/N 28-7816447N9225LTerry Mark B · Henderson, NCBuilt 1971 · S/N AA1A-0125N9225MSmith Carl L · Danville, KYBuilt 1966 · S/N 1184N9225NOrmond Aircraft Leasing & Management Inc · Ormond Beach, FLFirst renewal noticeBuilt 1989 · S/N 2841044N9225VDuncan Mark E · Marlton, NJBuilt 1969 · S/N 690048N9226CLane Community College · Eugene, ORBuilt 1978 · S/N 28-7816448N9226DClf Industries LLC · Thornton, COBuilt 1958 · S/N 22-6286N9226FLewis University · Romeoville, ILBuilt 1990 · S/N 4495011N9226HDebt LLC · Yuma, AZBuilt 1975 · S/N 17266026
Back to AD 90-04-06 R1