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.

N50ACRegistered aircraftBuilt 1994 · S/N 1200-94N50AHBrass Jeffrey A · Ackley, IABuilt 2003 · S/N 110N50AZBenson Aviation LLC · Mehoopany, PAS/N 2093N50BTWade William T · Fairhope, ALBuilt 1974 · S/N 28-7415164N50BXAthena Aviation LLC · Greenville, SCBuilt 2003 · S/N 10227N50CAllred & Associates Inc · Skaneateles, NYBuilt 1965 · S/N 891N50CABachmann Erik J · High Bridge, NJS/N CA001N50CLLopez Johnny · Henderson, NVBuilt 1976 · S/N 261-76N50CSBoretsky Bryan F · Lolo, MTBuilt 1961 · S/N 23-1973N50DCConrad David J · Wausau, WIBuilt 1993 · S/N 282N50DFCargille Joshua C · Kenosha, WIBuilt 1981 · S/N 122550N50DMMiller Cory L · Winnsboro, TXBuilt 1960 · S/N TD-332N50DPRenkel Christopher P · Westlake, OHS/N BROUSSARD 0001N50DTHarrell Ag Aviation LLC · Oak Grove, LABuilt 1975 · S/N 167-75N50EHSands Thomas · Columbia Falls, MTBuilt 2000 · S/N 2083N50ERFisher-Smith Jotham · Soquel, CABuilt 1978 · S/N AA5B0908N50FABeck Frank · Arvada, COBuilt 1972 · S/N AA5-154N50GDTranguch John M · Beaver Meadows, PABuilt 1966 · S/N MA-128N50GFHarrington Brian · Fountain Inn, SCBuilt 1950 · S/N 20-382N50GWWomack Craig D · Carlsbad, CABuilt 1993 · S/N 20370N50HBDyer Randall J · Frazier Park, CAS/N 3063N50HCFroggy Too LLC · Sheridan, WYBuilt 2025 · S/N 3456N50HFParagon Airplane Leasing Co · Fort Myers, FLBuilt 2023 · S/N 28020135N50HTDunteman William M · Big Rock, ILBuilt 1960 · S/N HH-131N50HURovegno Paul C II · Burlington, NCBuilt 1996 · S/N 1320N50HYGrossman David G · Itta Bena, MSBuilt 2000 · S/N 2116N50JAAday B Joe · Las Cruces, NMBuilt 1979 · S/N 18-8009002N50JKPorter Judson · El Paso, TXBuilt 2001 · S/N 25405N50JPPowell John R · Baton Rouge, LABuilt 2013 · S/N 24118N50JSSegura Speed Shop LLC · Henderson, TXBuilt 1992 · S/N S-032447-1N50JTRiba Scott S · Montrose, COBuilt 1960 · S/N 22-7287N50KMSexton David · Forney, TXBuilt 1991 · S/N 283N50KSShuman Kenneth R · Adrian, MIBuilt 2001 · S/N 20535N50LEFoulk Justin W · Yeagertown, PABuilt 1999 · S/N LE001N50LHRegistration Pending · Pensacola, FLRegistration pendingBuilt 2004 · S/N 81170N50LRHester Truck Sales Inc · Bladenboro, NCBuilt 1995 · S/N 749-95N50MDBeifia Bedia Rafael · Winchester, VABuilt 1984 · S/N PA604N50MHWolpin Stephen A · Santa Paula, CABuilt 1984 · S/N 1403N50MRWhite Gordon · Bulverde, TXBuilt 1993 · S/N 21720N50PFMitchell Kenneth A · Uniontown, PABuilt 1984 · S/N 28-8416084N50PGDrawe Richard · Progreso, TXBuilt 1994 · S/N 109575N50PJPremier Jets Inc · Hillsboro, ORBuilt 1976 · S/N AA5B-0287N50PKGuinn Dennis R · Nevada, TXBuilt 1968 · S/N 17701311N50RBBenson Ross A · Granbury, TXBuilt 1987 · S/N 757N50RCBuric Ivan Nmn · Panama City, FLBuilt 1974 · S/N 177-02087N50RJThomas Ken · Vancouver, WABuilt 2007 · S/N 1N50RSStone Raymond J · Felton, DEBuilt 1977 · S/N 24-0177N50SDLouisville Aviation LLC · Louisville, KYBuilt 1965 · S/N 3458N50SELenfestey Thomas J Jr · Wasilla, AKBuilt 1974 · S/N 28-7415514N50SUOhio State University · Columbus, OHBuilt 1998 · S/N 17280440
Back to AD 90-04-06 R1