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.

N218TSAeronautica LLC · West Hollywood, CABuilt 1966 · S/N 28-3675N218VGreen Gary E · Cotter, ARBuilt 2006 · S/N 45N218WGWilliams Sydney E · Kendallville, INBuilt 1969 · S/N 28R-35345N218WLN218wl LLC · Marshalltown, IABuilt 2004 · S/N 40.387N218WSOrourke Brendan W · Stoughton, WIBuilt 1979 · S/N 28-8090094N218ZMSkylink Xpress Inc · San Bernardino, CABuilt 1977 · S/N 15280011N2190PN2190p LLC · Titusville, FLS/N 23-799N2190TGonzales Rene V · Lampasas, TXBuilt 1971 · S/N 28-7205029N2191EBel Air Aviation LLC · Chesaning, MIFirst renewal noticeBuilt 1978 · S/N 28-7990179N2191JOefelein William A · Wasilla, AKBuilt 1960 · S/N 18-7185N2191LAir Leasing Service Inc · Hillsborough, NJS/N 28R-7918031N2191UJohnson Kenneth E · Mahtomedi, MNBuilt 1964 · S/N 402N2191WNorton Daniel J · Osage City, KSBuilt 1974 · S/N MB-727N2192QAdams Kenny G · Phelan, CABuilt 1974 · S/N 177RG0592N2192TMazza Frank · Bridgeton, NJBuilt 1971 · S/N 28-7205043N2192WRegistered aircraftS/N 22-2605N2193PDeem Adam C · Norton, OHBuilt 1990 · S/N 1795N2193QGerber John T · Lumberton, NCBuilt 1974 · S/N 177RG0593N2193VApm Leasing LLC · Casper, WYBuilt 1979 · S/N 44-7995266N2194KAviation Training LLC · Wilmington, DEBuilt 1978 · S/N 44-7995203N2194QMartin Dennis E · Oconto, WIBuilt 1974 · S/N 177RG0594N2194TNelson Donald M Jr · Fair Oaks, CABuilt 1971 · S/N 28-7205045N21950Cousins Mark T · Portland, ORS/N 17264046N21956Lake Elmo Flyers LLC · Vadnais Heights, MNBuilt 1974 · S/N 17264048N2195EZameroski Daniel C · Mckean, PABuilt 1978 · S/N 28-7990182N2195LGinsberg Andrew P · Rochester, NYBuilt 1979 · S/N 28R-7918032N2195PZahlmann Daniel R · Queen Creek, AZS/N 23-803N2195QWatters Claytus James · Magnolia, TXBuilt 1974 · S/N 177RG0595N2196QGillette William · Northbrook, ILBuilt 1974 · S/N 177RG0596N2196SHernandez Christopher A · Phoenix, AZBuilt 1968 · S/N 180753N2196TTilly Curtis L · Raleigh, NCBuilt 1971 · S/N 28-7205047N2196UZeiner Gary R · Greencastle, INBuilt 1964 · S/N 407N2196VFixed Wing Holding Co Inc · Pembroke Pines, FLBuilt 1979 · S/N 44-7995267N2197QCarnahan Benjamin J · Grass Valley, CAS/N 177RG0597N2197TAdams Donald L · Huntsville, ALBuilt 1971 · S/N 28-7205048N2197WSmothers Edward Jr · Owasso, OKBuilt 1974 · S/N MB-697N2197XKelley Brian S · Vancouver, WAS/N 23293N21985N21985 LLC · Deltona, FLBuilt 1978 · S/N 28-7990066N2198ACrowl Jack A · Ashton, IABuilt 1952 · S/N 22-615N2198PAerotrack Inc · Hemet, CABuilt 1956 · S/N 23-808N2199PPowers Edward · Stormville, NYS/N 23-809N2199TKeith Brothers Aviation LLC · Fort Worth, TXBuilt 1971 · S/N 28-7205051N219AMeridian Aircraft LLC · Wilmington, DEBuilt 2014 · S/N 2843788N219BJTaylor Kennedy E · Courtland, MSBuilt 1967 · S/N 28-22813N219CDCd Flyers LLC · Port Orange, FLBuilt 2001 · S/N 1124N219CFJohnson Francis W · Krugerville, TXS/N 44BF02N219DBN219db LLC · Bryan, OHBuilt 1966 · S/N 28-2970N219DCMjz Ventures LLC · Dodge City, KSBuilt 2023 · S/N 11180026N219DSJojo & Dino Ltd · Frederick, MDBuilt 2002 · S/N 40.219N219EPEpic Aviation Inc · New Smyrna, FLBuilt 2019 · S/N 4496458
Back to AD 90-04-06 R1