OpenAirDocs.org
AD 2007-04-19 R1

Registered aircraft · 108,433

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:2007-04-19-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:2007-04-19-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.

N21WYRegistered aircraftBuilt 2012 · S/N 3171N21WZPlumb Ray A · Salida, COBuilt 2000 · S/N 2637N21XCHeaton Joshua · Allen, TXBuilt 2000 · S/N 40007N21XGPrivitt Bret · Hudson Oaks, TXBuilt 1982 · S/N 1007N21XLMilligan Edward · Beaverton, ORS/N 1000N21YCp Aviation Inc · Santa Paula, CABuilt 1954 · S/N 30837N21YYShep Air Inc · Cedar Rapids, IABuilt 2005 · S/N 1664N21ZZMadshack Aviation LLC · Reston, VABuilt 1962 · S/N NAV-4-2405N220Atlantic Coast Aviation Inc · Dover, DEBuilt 2002 · S/N 0177N2200GCarey Alan W · Fallon, NVBuilt 1958 · S/N 51500N2200JOld Prairie Products Inc · Angola, INBuilt 1979 · S/N 32R7985041N2200SPa32 Aviation LLC · Blue Bell, PABuilt 1979 · S/N 32-7940055N2200YBarber Aviation LLC · Wilmington, DEBuilt 1979 · S/N 28-7911146N2201AJulius Air LLC · Lewes, DEBuilt 1978 · S/N 24-0559N2201LHorizon Enterprises Vne LLC · Aurora, COBuilt 1976 · S/N D-9938N2201MSteck Richard E · Arlington Heights, ILBuilt 1978 · S/N 24-0560N2201PRm Stoudt Inc · Jamestown, NDBuilt 1978 · S/N 24-0561N2201QBocaj Air LLC · Irving, TXBuilt 1978 · S/N 24-0562N2201RMize Helicopter LLC · Grand Prairie, TXBuilt 1978 · S/N 24-0564N2201TCiupitu Marc P · Houston, TXBuilt 1971 · S/N 28-7105182N2201UChrisara Investments LLC · Carson City, NVBuilt 1997 · S/N EA-601N2201YInternational Air Services Inc Trustee · Carson City, NVBuilt 1967 · S/N 17700001N2202AArtisan Aviation Inc · Rochester, NYBuilt 1978 · S/N 28-7916102N2202BRegistration Pending · George West, TXRegistration pendingS/N 6629N2202PMacair Aviation LLC · Xenia, OHBuilt 1956 · S/N 23-812N2202QLewis University · Romeoville, ILBuilt 2007 · S/N 172S10517N2202UAsp Legacy Holdings Corp · SpringwaterBuilt 1979 · S/N 32-7940061N2202WMiloud Chadd K · Fort Worth, TXBuilt 1979 · S/N 28-7916332N2202YStanley Aviation LLC · Colby, KSS/N 28-7911147N2202ZHazlewood Norman R · Wichita, KSBuilt 1981 · S/N 28-8116278N22034Robertson David L · Ray, MIBuilt 1974 · S/N 17264052N2203ASs Three LLC · North Platte, NEBuilt 1978 · S/N 28-7990111N2203DWhytes Inc · Coconut Creek, FLBuilt 1978 · S/N 28-7916148N2203FElk Flyers Inc · Saint Marys, PABuilt 1978 · S/N 28-7990191N2203GBartek John · Glenwood Springs, COBuilt 1958 · S/N 51503N2203LForni Robert · Spring Grove, ILBuilt 1976 · S/N CE-669N2203MLane Aviation Academy · Eugene, ORBuilt 1977 · S/N 28-7816258N2203POne More Time Aviation Inc · Bossier City, LABuilt 1956 · S/N 23-813N2203RHubin Scott E · Kent, OHBuilt 1975 · S/N AA5B-0071N2203TGateway Flight Training LLC · Saint Louis, MOBuilt 1979 · S/N 28-7916300N2203VSnyder Jeffrey L · Annapolis, MDBuilt 1979 · S/N 28-7916326N22044182 Flight Corp · Bronx, NYBuilt 2005 · S/N 18281671N2204ATbl Aviation LLC · Meridian, IDBuilt 1978 · S/N 28-7911006N2204CPainter Creek Lodge Inc · El Rito, NMBuilt 1953 · S/N 30504N2204DOvercast Dan · Columbia City, ORBuilt 1978 · S/N 28-7916149N2204LMccann Richard H · Shuqualak, MSBuilt 1999 · S/N 29-0209N2204TNgugi Samson W · El Paso, TXBuilt 1971 · S/N 28R-7135168N2204ULi'L Dawg Aviation Inc · Florence, ALBuilt 1979 · S/N 32-7940065N2204XAirgo Inc · Centralia, ILBuilt 1979 · S/N 44-7995281N2204YEagle Sky Patrol Inc · Deadwood, SDS/N 17700004
Back to AD 2007-04-19 R1