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.

N12GNNauta Gordon Wayne · Palmdale, CABuilt 1977 · S/N 112N12GRJones Richard B · Georgetown, TXBuilt 2001 · S/N 2152N12HBAerotechniques LLC · South Kent, CTBuilt 1977 · S/N 177RG1124N12HCBirdwin LLC · Buras, LABuilt 1978 · S/N 909N12HEOlafsen George F · Greeneville, TNBuilt 2007 · S/N 91367N12HFParagon Airplane Leasing Co · Fort Myers, FLBuilt 2023 · S/N 28020131N12HGNaylor John H · Conway, ARS/N 1N12HHWilliams Jeffrey · Florence, ALBuilt 1989 · S/N 1688N12HRHarben Grover S III · Gainesville, GABuilt 1991 · S/N 1664N12HTRanieri Paul A · Palatine, ILBuilt 2012 · S/N 5044N12HUVintage Flyers LLC · The Villages, FLBuilt 1997 · S/N 1345N12HYRegistration Pending · Nephi, UTRegistration pendingBuilt 1999 · S/N 1448N12HZBaldauf Ryan L · Spencerville, OHBuilt 1976 · S/N 17266707N12JVRaun Ian O · Sharpsburg, MDBuilt 1979 · S/N 88N12KBWings Over Texas Holdings LLC · Denton, TXBuilt 1973 · S/N 17261915N12KDDeeble Kenneth M · Dayton, MTBuilt 1979 · S/N 596-80N12LGLapiair LLC · Vergennes, VTBuilt 1998 · S/N 20418N12LMHaney Andrew J · Mt Morris, PAS/N 1001N12LPBlewett John Thomas Jr · Springfield, GABuilt 1998 · S/N 21056CN12LTBaker William A · Lincolnton, NCBuilt 1972 · S/N 406N12LZConlon Joseph F · Gainesville, FLBuilt 2011 · S/N LZ001N12MFitzpatrick H Mike · Cleveland, GABuilt 2010 · S/N 60548N12MBHarrison Hayden F · Mckean, PAS/N 1948N12MJCruiseair Aviation Inc · Ramona, CABuilt 1972 · S/N 17261299N12MPMarcus Robert L · Dallas, TXBuilt 1963 · S/N 30-284N12MVKarduck Craig · Morgan, UTS/N 3671N12NCPeck Nathan M · Leavenworth, KSBuilt 1994 · S/N 1741-LN12PShalun Lukas A · Germantown, TNBuilt 1977 · S/N 001N12PKDuncan Aviation Inc · Lincoln, NEBuilt 2000 · S/N 2103N12PNRegistration Pending · Maitland, MORegistration pendingBuilt 1998 · S/N 1243-98N12PSMurphy Peter · Johns Creek, GABuilt 1981 · S/N 44-8107047N12PZA5 Flight Club LLC · Saint Cloud, FLBuilt 1974 · S/N AA5-0622N12QRWilson Koby D · Southside, ARBuilt 2000 · S/N 2121N12RDoll John M · Austin, TXBuilt 1976 · S/N 0744N12REWilliams Jeffrey · Georgetown, INBuilt 1982 · S/N EPPLETT-0001N12RZZapsky Richard M Jr · Houtzdale, PABuilt 2000 · S/N 5585N12SFToller Rick L · Crescent City, FLBuilt 1977 · S/N 814N12SVHarmacinski Larry Trustee · Punta Gorda, FLBuilt 1947 · S/N 418N12TASky West Aviation Inc Trustee · Albuquerque, NMBuilt 1958 · S/N 22-6319N12TCCb22 Holdings LLC · Price, UTBuilt 1977 · S/N 28-7790417N12TESchwigen Justin R · Alton, ILBuilt 1998 · S/N 1440N12TLLoofbourrow Travis S · Houston, TXBuilt 1968 · S/N 60N12TQWyoming Aeroflight LLC · Laramie, WYBuilt 1994 · S/N 1270N12TRRegistered aircraftBuilt 1991 · S/N 10053N12TSSmith Thomas R C · Suisun City, CABuilt 2001 · S/N 1353N12VEMorrison Benjamin Franklin III · Godley, TXBuilt 1983 · S/N 32365279N12VGHashimoto Noriyuki · Rumford, MEBuilt 1971 · S/N AA1A-0187N12VSCal-Aerofab Flight Academy · Chino, CABuilt 2008 · S/N 71542N12WAIoe Aviation LLC · Kirkland, WABuilt 1994 · S/N 21712N12WKGallagher Glenn C · Lakeland, FLBuilt 1984 · S/N 5811
Back to AD 90-04-06 R1