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.

N3614XPanther Enterprises LLC · Fort Myers, FLS/N 5090N3614YEmission -Air Inc · Lexington, NCBuilt 1962 · S/N 21058114N36150Bas Part Sales LLC · Greeley, COBuilt 1978 · S/N 32R-7885166N3615CMarkwardt Jacquelyn K · Santa Cruz, CABuilt 1954 · S/N 31113N3615MRenfro Michael W · Bethel, AKBuilt 1947 · S/N 12-2461N3615NWalker Eric L · Southlake, TXBuilt 1967 · S/N 680012N3615QPlane Safe Aircraft Maintenance Inc · Waukesha, WIS/N MB-237N36167James Brett · Louisburg, NCBuilt 1978 · S/N 28-7890497N3616DRobinson Mark V · Vacaville, CAFirst renewal noticeBuilt 1956 · S/N 35316N3616NDe Masters Jasper · Bakersfield, CABuilt 1967 · S/N 680013N3616PKidd Myles · Machesney Park, ILBuilt 1955 · S/N 22-3344N3616UHatch Koay A · Gilbert, AZBuilt 1963 · S/N 18255016N3616YAnderson Dana R · Redding, CABuilt 1962 · S/N 21058116N36173Schuster Darin D · New Castle, DEBuilt 1973 · S/N 546-73N36176Otte Duane P · Plainfield, INBuilt 1973 · S/N 101-73N36178California Flyers Training Solutions LLC · Sun City, CABuilt 1973 · S/N 383-73N3617PPhilpott Gary D · Camden, SCBuilt 1956 · S/N 22-3723N3617YSchindele Micheal D · Tolna, NDBuilt 1962 · S/N 21058117N36185Stapleton Rita · Gallipolis, OHBuilt 1978 · S/N 32R-7885169N36187Swaz Aviation LLC · Mesa, AZBuilt 1978 · S/N 28-7816619N3618CHoshor Matthew David · Wetumpka, ALBuilt 1978 · S/N R18200278N3618GIndustrial Consulting LLC · Repton, ALBuilt 1956 · S/N 35313N3618MRatcliffe Andrew M · Jerome, AZBuilt 1978 · S/N 28-7890319N3618NYoung Donald Colin · West Plains, MOBuilt 1967 · S/N 680014N3618XHildenbrand Casey E · Circleville, OHBuilt 1968 · S/N 5095N36194Cripps Alan Stephen · Hoover, ALBuilt 1978 · S/N 32R-7885171N3619CHamby Michael R · Parma, IDBuilt 1954 · S/N 31117N3619JFisher Ag Service LLC · Cardington, OHBuilt 1979 · S/N T18803565TN3619KKirk Trevor A · Ponderay, IDBuilt 1967 · S/N 28-23656N3619NChiques Aero Corporation · Lancaster, PABuilt 1967 · S/N 680015N3619RBachelor Cabin Flying Services Inc · Kokomo, INBuilt 1969 · S/N 28-5714N3619XNeeds Shaely M · Pueblo, COS/N 5096N3619YWilliams Jimmy Z · Sherman, TXBuilt 1962 · S/N 21058119N361ACBond Robert E · Kingsville, MOBuilt 1974 · S/N 497-75N361AHHodge Cleophas U · St Thomas, VIBuilt 1980 · S/N TJ-308N361AKAronson Kenneth I Trustee · Truckee, CABuilt 2016 · S/N 91935N361CPBarr Air Patrol LLC · Mesquite, TXBuilt 2001 · S/N 172S8840N361CWCk Aviation LLC · Brookhaven, MSBuilt 1980 · S/N E-1755N361DNeill James H · Keller, TXBuilt 1965 · S/N CD-865N361DBLcb Leasing · Manassas, VAFirst renewal noticeBuilt 2010 · S/N 18282245N361DMLeibstein Guy · Babylon, NYBuilt 1975 · S/N E-670N361ESGrady Paul D · Reno, NVBuilt 1997 · S/N 17280011N361ETW Fairfield Aviation Inc · Caldwell, KSS/N 437N361FSBlue Yonder Aviation Inc · Rochester, NYBuilt 1997 · S/N 23039CN361GAGlidewell Aviation Inc · Parkland, FLBuilt 2003 · S/N 172S9521N361GCFff Leasing LLC · Dover, DES/N 414-0616N361JBCarroll Farm Management Company · Carthage, ILBuilt 2005 · S/N 1253N361JFFuller James K · Goliad, TXBuilt 2008 · S/N 12172N361KWFliteco Holdings LLC · Lewes, DEBuilt 1981 · S/N EA-264N361LRegistered aircraftBuilt 2004 · S/N 172S9569
Back to AD 2007-04-19 R1