AD 2007-04-19 R1

Registered aircraft · 108,434

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.

N4096DSkydive Cape Cod Inc · Caddo Mills, TXBuilt 1958 · S/N 34796N4096ESwiss John T · Anchorage, AKBuilt 1978 · S/N 18-7809064N4096SSmith Timothy M · Mount Pleasant, WIBuilt 1975 · S/N TC-1842N4096XFoster Robert L Jr · Chandler, OKBuilt 1970 · S/N 5196N4096ZTurner Hal Eugene Jr · Tiburon, CAS/N 18-8110N40972Terry Aaron D · Glendale, AZS/N 28-7425196N40978Dodson International Parts Inc · Rantoul, KSBuilt 1981 · S/N 31-8152199N4097LSinkule Jim · West, TXBuilt 2007 · S/N 12072N4097MN4097m LLC · Boynton Beach, FLBuilt 1998 · S/N 17280322N4097XWilson Dane A · Church Point, LABuilt 1971 · S/N 5197N4097ZSullivan Daniel J · Long Lake, MNBuilt 1964 · S/N 18-8111N40982Seneca Aviation LLC · Wheaton, MDBuilt 1974 · S/N 34-7450095N40984Four Zero Niner LLC · Granger, IABuilt 1973 · S/N 28-7425199N40987Besl Thomas J · Cincinnati, OHBuilt 1973 · S/N 28-7415126N4098DAspegren Robert N · Vacaville, CABuilt 1958 · S/N 34798N4098FN4098f LLC · Ypsilanti, MIBuilt 1976 · S/N 28-7715004N4098XOstgard William R · Mims, FLS/N 5198N4098ZChant J Archie · Riverton, WYBuilt 1964 · S/N 18-8112N40993Premier Capital Enterprises LLC · Hurricane, UTBuilt 1974 · S/N 28-7405159N4099EReel Chad · Wasilla, AKS/N 18-7809066N4099NS O Witt And Associates LLC · Ridgecrest, CAS/N 680174N4099SDodson International Parts Inc · Rantoul, KSBuilt 1975 · S/N TE-1037N4099XMiller Aviation Group LLC · Coon Rapids, MNBuilt 1971 · S/N 5199N4099ZMayes Brett R · Williams, CABuilt 1964 · S/N 18-8113N409ACHighland Holdings LLC · Bethlehem, PABuilt 1966 · S/N 336N409AFThomas Douglas M Jr · Blue Bell, PABuilt 1966 · S/N 28-21915N409BKHyannis Air Service Inc DBA · Hyannis, MABuilt 1982 · S/N 402C0651N409BWBarrett Transportation LLC · Mount Pleasant, TNS/N 3080N409CACoast Flight Training And Management Inc · Dallas, TXBuilt 2019 · S/N 2881120N409CCPappy Air LLC · Pickerington, OHBuilt 2023 · S/N 28020113N409CDArmbruster LLC · Amherst, OHBuilt 2005 · S/N 1286N409CQPaper Airplane Co LLC · Broomfield, COBuilt 2018 · S/N 18283041N409CRChristiansen Aviation LLC · Wilmington, DEBuilt 2014 · S/N 172S11440N409CVCivil Air Patrol · Maxwell Afb, ALBuilt 2016 · S/N 18282443N409DParagon Flight Training Co · Fort Myers, FLBuilt 2025 · S/N 28020224N409DCSpitzer Helicopter LLC · Wilmington, DES/N 13710N409ESN409es LLC · Stuart, FLBuilt 1997 · S/N 17280231N409FDSouth Seas Aviation Ltd · Wilmington, DEBuilt 1987 · S/N 726N409FPAamro Aviation Corp · Lake Worth, FLNon-citizen corporation, flight hours not reportedBuilt 2006 · S/N 40.FC009N409JBPenstar Partners LLC · Wilmington, DEBuilt 1969 · S/N 60003988N409KJBoard Of Trustees · Battle Creek, MIBuilt 2021 · S/N 4496523N409LAAnderson Wilma (Lori) · Blue Mound, ILS/N 24-1494N409LPSolberg Aviation Co Inc · Whitehouse Station, NJS/N 172S9409N409MFenton Richard O · Weatherford, TXBuilt 1969 · S/N D-8981N409MBNiner LLC · Wilmington, DEBuilt 2023 · S/N 14621N409MMStormer Isaac E · Curtis, WABuilt 1981 · S/N 154N409NSGonzalez John E · Malibu, CABuilt 2012 · S/N 40409N409PValiair Limited Co Trustee · Casper, WYBuilt 2005 · S/N E-3656N409PDIowa Great Lakes Flyers Inc · Cheyenne, WYBuilt 1973 · S/N CE-450N409PKSky Cowboy Supply Co LLC · Cape Elizabeth, MEBuilt 1978 · S/N 18503721
Back to AD 2007-04-19 R1