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.

N5604SThrasher Luke DBA · Amarillo, TXBuilt 1966 · S/N D-8156N5604UShumaker Grant H · Dakota Dunes, SDBuilt 1969 · S/N 28-26532N5604WHustedde Trucking LLC · Fayette, MOBuilt 1962 · S/N 28-741N56050Seidel Seth · Ellington, CTBuilt 1973 · S/N 28R-7335340N56055Murray Patrick Calvin Jr · Port Orchard, WABuilt 1973 · S/N 28-7325563N5605JMajor Air LLC · Charleston, SCS/N 17273819N5605PAurnou Marshall E · Marco Island, FLBuilt 1959 · S/N 24-673N5605QBennett Steven D · La Fayette, GABuilt 1965 · S/N 759N5605SDevereaux Saw Mill Inc · Pewamo, MIBuilt 1966 · S/N D-8319N5605UN5605u LLC · Nottingham, NHBuilt 1969 · S/N 28-26534N56063Powell James M III · Columbia, SCBuilt 1973 · S/N 28R-7335344N56066Trojan Aviation LLC · Kailua Kona, HIBuilt 1973 · S/N 28R-7335346N5607UWilliams Richard Dale · Tucson, AZBuilt 1969 · S/N 28-26535N5607WFrost Jack D II · Goodrich, MIS/N 28-745N56083Rock Solid Aviation LLC · Lake Charles, LABuilt 1973 · S/N 28-7325565N56085Donohue John T · Big Bear Lake, CABuilt 1973 · S/N 28R-7335348N56086Cacolici Dominic · Saint Petersburg, FLBuilt 1973 · S/N 28R-7335349N5608KRyan Carroll M · Redding, CABuilt 1964 · S/N CD-750N5608USchoenberger Amber J · Niceville, FLS/N 28-26537N56090Wood William J · Jackson, GABuilt 1973 · S/N 28-7325570N56098Wong Yi C · Aurora, COBuilt 1973 · S/N 28-7325571N5609BWinkelman Ronald A · Chugiak, AKBuilt 1956 · S/N 33609N5609KNewell Edwin R · Ocean Isle Beach, NCBuilt 1964 · S/N CD-746N5609LTaylor Darius · Fayetteville, GABuilt 1972 · S/N AA5-0209N5609SSimply Living LLC · Fort Myers, FLBuilt 1990 · S/N CE-1454N5609USteves Landavator Service LLC · Oley, PAS/N 28-26539N560APa28 Aircraft LLC · Wilmington, DEBuilt 2014 · S/N 2843763N560ABQuartermaster Growth LLC · Vashon, WABuilt 2007 · S/N 18281947N560BBSednal Enterprises · Los Gatos, CABuilt 1994 · S/N EA-562N560BYShogbonyo Michael A · Arlington, TXBuilt 1973 · S/N 28R-7335333N560CDKlohn Volker · Houston, TXBuilt 2005 · S/N 1644N560CPStory Charles M · Leesburg, FLBuilt 2002 · S/N 369N560DKN560dk LLC · Newark, DEBuilt 2023 · S/N 254N560EHSafeflightops LLC · Venetia, PAS/N 10589N560FASteffel Farms LLC · Olivia, MNBuilt 2003 · S/N 172S9560N560FLBancroft Robert W · Aurora, NYBuilt 1975 · S/N 28-7625026N560MWRegistered aircraftBuilt 2011 · S/N 72633N560PUPurdue Aviation LLC · West Lafayette, INBuilt 2000 · S/N 2842098N560RJJenaero LLC · Cincinnati, OHBuilt 1993 · S/N 7637N560TZukauckas George F · Cave Creek, AZBuilt 1961 · S/N CD-341N560TCCacek Thomas E · Crescent City, FLBuilt 1995 · S/N TC2N560THLe Tourneau University · Longview, TXBuilt 2016 · S/N 172S11668N560XWullschleger Kevin D · Avon, INBuilt 1965 · S/N TC-968N560ZHeslin Jon P · Sutton, MABuilt 1974 · S/N 17262889N561Jacobsen John O · Prescott, AZS/N TE-918N56101Seniram Air Inc · Wilmington, DEBuilt 1973 · S/N 28R-7335354N56105Anderson Wendell R · Brainerd, MNBuilt 1973 · S/N 28-7325573N5610JRael Pedro G · Los Lunas, NMBuilt 1974 · S/N 18263465N5610KAdams Timothy C · Ozark, ALBuilt 1964 · S/N D-7378N5610QRustad Scott K · Minot, NDBuilt 1965 · S/N 709
Back to AD 2007-04-19 R1