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.

N20402Fosdick Kenneth E · Plymouth, MABuilt 1972 · S/N 17261261N20403Deatherage Edward D · Salina, KSBuilt 1977 · S/N 17702669N20404Air Data Solutions LLC · Natchitoches, LABuilt 1972 · S/N 17261263N20405Buffalo Wings LLC · Overland Park, KSS/N 17261264N20406Sp Airparts LLC · Moscow, IDS/N 17261265N2040ASchultz Philip W · Lancaster, CABuilt 1969 · S/N D-9024N2040CWatson Anthony A · Midlothian, TXBuilt 1977 · S/N E-1135N2040GFinal Forge LLC · Blountville, TNBuilt 1978 · S/N E-1380N2040HAbc Plane LLC · Freeport, TXS/N 18281639N2040LLake Fun Llp · Terre Haute, INBuilt 1968 · S/N 373N2040PTrb Aviation LLC · Fredericksburg, VABuilt 1978 · S/N D-10183N2040REco Flite Service Inc · Lake Elsinore, CABuilt 1964 · S/N 18255240N2040UGillim Parvin D · Sheridan, INBuilt 1978 · S/N E-1381N2040XBas Part Sales LLC · Greeley, COBuilt 1965 · S/N 18256140N2040YCappel Eric H · Satellite Beach, FLBuilt 1978 · S/N D-10181N20410Widjokongko Antonius · League City, TXBuilt 1977 · S/N 17702670N20412Atpce LLC · Wilmington, DEBuilt 2020 · S/N 172S12520N20413Colton Terence J · Point Roberts, WABuilt 1972 · S/N 17261270N20416Carl L Mccallister Inc · Wilmington, DEBuilt 2005 · S/N 18281642N20417Atpce LLC · Wilmington, DEBuilt 2020 · S/N 172S12522N20418Pierce Scott W · Fredonia, NYBuilt 1972 · S/N 17261273N2041GSmith Stacey · Malakoff, TXS/N 51341N2041LSlik Air LLC · Topeka, KSBuilt 1976 · S/N M-1849N2041PManke Brian W · Chesapeake, VABuilt 1978 · S/N CE-821N2041RBlair Darrell E · Trinity, NCBuilt 1969 · S/N 28-5440N2041WJimenez John D · San Antonio, TXS/N D-7982N2041ZBlue Mesa LLC · Bend, ORBuilt 1978 · S/N TE-1144N20420N83993 LLC · Cherry Hill, NJBuilt 1972 · S/N 17261275N20421West Michigan Flying Club Inc · Norton Shores, MIBuilt 1972 · S/N 17261276N20422Atpce LLC · Wilmington, DEBuilt 2020 · S/N 172S12523N20423Lowcountry Flight LLC · Johns Island, SCBuilt 1972 · S/N 17261278N20425Atpce LLC · Wilmington, DEBuilt 2020 · S/N 172S12524N20427Sleight Craig R · Prineville, ORBuilt 1972 · S/N 17261280N2042BHasemann James M · Gaithersburg, MDBuilt 1978 · S/N D-10185N2042CDms Leasing Co LLC · Las Vegas, NVS/N TD-219N2042ESmith James E Trustee · Kalispell, MTS/N TC-2188N2042QKachemak Bay Flying Service Inc · Temple, TXBuilt 1975 · S/N 17265453N2042RJanssen David W · Ault, COBuilt 1964 · S/N 18255242N2042YPierson Daniel D · Kalispell, MTS/N G-826N2043Precision Aero LLC · Wilmington, DEBuilt 1998 · S/N 28008CN20430Jets To Helis LLC DBA · Chandler, AZBuilt 1989 · S/N 1236N20431Organization Of Black Aerospace Professionals · Westchester, ILBuilt 1972 · S/N 17261283N20437Wingsleasing LLC · Wichita, KSBuilt 1972 · S/N 17261287N20439Wilken Virginia · Sequim, WABuilt 1972 · S/N 17261289N2043ACampion Richard · Tampa, FLBuilt 1978 · S/N TH-983N2043CLouisiana Community And Technical College System · New Iberia, LABuilt 2008 · S/N 0329N2043GBreaking Wind LLC · Alabaster, ALBuilt 1978 · S/N TC-2189N2043LBrown Dennis · Moncks Corner, SCBuilt 1976 · S/N M-1856N2043MPaxton Flyers · Loda, ILBuilt 1977 · S/N 28-7816241N2043RBoltjes Thomas S · Platte, SDBuilt 1969 · S/N 28-5441
Back to AD 2007-04-19 R1