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.

N41BPSturdevant Harold L Jr · Kalispell, MTS/N 30-644N41BXWilliams Paul E · Kendallville, INBuilt 1981 · S/N 18053197N41CEWhats Up Doc Aviation LLC · Alexander, ARBuilt 1978 · S/N 21062872N41CHLaperle Brian D · Colebrook, NHBuilt 1956 · S/N 32319N41CSSanders Aviation Services LLC · Hedgesville, WVBuilt 1996 · S/N 20403N41CVGoldfinger Chris · Albany, ORBuilt 2002 · S/N 160N41DBryson Zachary · Redondo Beach, CAS/N AA5B0993N41DCDc Aircraft LLC · Shreveport, LABuilt 1953 · S/N G-106N41DDDurbano David · Jackson, WYBuilt 2017 · S/N CC19-0019N41DLLdair Inc · Roanoke, VABuilt 2002 · S/N 18281142N41DMMission Air LLC · Oklahoma City, OKBuilt 1959 · S/N 23-1566N41DNNevels Donald L · Everton, MOBuilt 1984 · S/N DLN01N41EBCoakes Randall S · Lafayette, INBuilt 2004 · S/N 40.445N41ECTreeline Helicopters Inc · Bristol, TNS/N TH-471N41EGSal Aviation Inc · Wilmington, DEBuilt 1978 · S/N TK-75N41EKPrairie View Energy II LLC · Granite Falls, MNBuilt 1978 · S/N 32R-7885096N41ERDeiulio Michael · Carle Place, NYBuilt 1978 · S/N AA5B0910N41EXFox James R · Saint Paul, MNBuilt 2005 · S/N 1195N41FAKingsky Flight Academy LLC · Lakeland, FLBuilt 1979 · S/N 17272997N41FROplnet LLC · Arlington, VABuilt 1972 · S/N E-371N41GCmg Helicopters LLC · Summerfield, LABuilt 1969 · S/N 291097(67-16990)N41GBBoeing Co · Berkeley, MOBuilt 1987 · S/N 1161N41GCAviation Of North Florida LLC · Jacksonville, FLBuilt 1956 · S/N 33612N41GDValiair Lc Trustee · Casper, WYS/N 401B-0218N41GLGiegler Adam J · Cypress, TXS/N 23924N41GSGolf Sierra LLC · West Palm Beach, FLBuilt 1980 · S/N 61P08098063419N41GVRbs Inc · Wht Sphr Spgs, WVBuilt 1977 · S/N 18265837N41HCDkh Air LLC · Shady Shores, TXBuilt 1974 · S/N E-592N41HDHerman Edward G · Pitkin, COBuilt 1979 · S/N 41N41HMSale Reported · Reno, NVSale reportedBuilt 2017 · S/N 73954N41HRTw Aviation LLC · Missoula, MTBuilt 2011 · S/N E-3946N41HSStevens Randall L · Abilene, TXBuilt 2007 · S/N 101N41HTJacobs Gregory R · Pinole, CABuilt 1998 · S/N 29-0149N41HYWillcutts William D · Greeley, COS/N 2168N41JAJersey Aero Club · Lakewood, NJBuilt 1997 · S/N 2843081N41JMAmerican Aviation Automotive Enterprises LLC · Lewes, DEBuilt 1982 · S/N 432N41JRDarnall Jeffery D · Jacksonville, FLBuilt 1993 · S/N 3172N41KFThomas Wayne · Powell, OHBuilt 1968 · S/N 28R-30505N41KKDale Aviation LLC · Wilmington, DEBuilt 1979 · S/N 6006477961205N41LPulliam Oscar E Jr · Moscow, TNBuilt 1958 · S/N 24-351N41LACathriner Richard J · Plano, TXBuilt 2009 · S/N 263-320-28N41LCBowen William A III · California, MDBuilt 1972 · S/N 310Q0502N41LDThomas James A · Yukon, OKBuilt 1989 · S/N 41N41LLNotjets LLC · Paradise Valley, AZBuilt 1980 · S/N E-1644N41LSGendron Chistofer P · Prospect Park, PABuilt 1952 · S/N 20-862N41LYFedflyt LLC · Russell Springs, KYBuilt 2017 · S/N 30020N41MCGarner John B · Newark, DEBuilt 1984 · S/N 18268379N41MEFlydreams Aircraft Group Inc · Fort Lauderdale, FLBuilt 1978 · S/N 17269389N41MMRiester Robbin W · Navarre, FLS/N 310H0017N41MQParsons Douglas L · Carrollton, OHBuilt 1978 · S/N 18266506
Back to AD 2007-04-19 R1