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.

N4470YAmundson Daryl A · Blue Earth, MNBuilt 1966 · S/N 25-4124N4470ZRegistration Pending · Weatherford, TXRegistration pendingBuilt 1969 · S/N 18-8819N44710Bonin David P · Belmond, IABuilt 1974 · S/N 28-7515012N44714Burchfield Bill · Tanner, ALBuilt 1974 · S/N 28-7515013N44715Skogen Karl L · White Bear Lake, MNBuilt 1974 · S/N 28-7515014N4471EWolfe John · Marathon, FLBuilt 2001 · S/N E-3394N4471JN4471j LLC · Dover, DEFirst renewal noticeBuilt 2011 · S/N 13106N4471NSpitzer Helicopter LLC · Wilmington, DEBuilt 2011 · S/N 4508N4471RMurray Carol A · Hilo, HIBuilt 1976 · S/N 18502964N4471ZEgolf Charles F · Spokane, WAS/N 18-8821N4472DSky Helicopters Inc · Desoto, TXBuilt 2025 · S/N 4913N4472FA&J Aircraft Leasing Inc · Burlington, COBuilt 1976 · S/N 28-7715034N4472HSalamon Uri · Boerne, TXBuilt 1978 · S/N 24-0743N4472MStone Aviation Enterprises Inc · East Syracuse, NYS/N PRICE 1N4472RFlyrite Aviation LLC · Fort Myers, FLBuilt 1974 · S/N 17263214N4472YSilent Flight LLC · Payette, IDBuilt 1966 · S/N 25-4128N4473FPate Elaine · Thousand Oaks, CABuilt 1976 · S/N 28-7715035N4473JAj Aviation LLC · Gwinner, NDBuilt 1967 · S/N 28-22889N4473PSemeniuk Steven T · Houston, TXS/N 23-2018N4473RMiller Keith A · Reedy, WVBuilt 1974 · S/N 17263215N4473XSlipstream Aviation LLC · Calera, ALBuilt 1975 · S/N 28-7690018N4473ZEriksen Rodney B Trustee · Juneau, AKBuilt 1969 · S/N 18-8822N44747Goldenburg Timothy A · Ypsilanti, MIBuilt 1974 · S/N 32-7500001N44749Hoprich Jeffrey S · Roanoke, VABuilt 1974 · S/N 28-7515021N4474FN44107 LLC · Marlton, NJBuilt 1976 · S/N 28-7790029N4474MN4474m Inc · Camarillo, CABuilt 2001 · S/N EA-674N4474STailwind Aviation LLC · New Rochelle, NYBuilt 1975 · S/N E-698N4474WR And S Aviation LLC · Corning, ARBuilt 1974 · S/N TH-431N4474XToledo City School District · Swanton, OHS/N 28R-7635054N4474ZWatts Craig W · Incline Village, NVBuilt 1969 · S/N 18-8824N44753Registration Pending · Torrance, CARegistration pendingBuilt 1974 · S/N 28-7505006N44754Greenville Pickens Roundtrac LLC · Easley, SCBuilt 1974 · S/N 28R-7535003N4475ARyan Justin M Jr · Rch Palos Vrd, CABuilt 1970 · S/N TE-807N4475JHilburn Brian · Philadephia, PABuilt 1967 · S/N 28-22891N4475PRamaswamy Gautam · Clearwater, FLBuilt 1961 · S/N 23-1997N4475RBrown Charles A · Portland, TXBuilt 1978 · S/N R18200604N4475TWings Over Texas Holdings LLC · Denton, TXBuilt 1972 · S/N 34-7250106N44761Henderson Gregory S · Saltsburg, PABuilt 1974 · S/N 28-7515025N44763Flying Peanuts LLC · Wilmington, DEBuilt 1974 · S/N 28-7505007N44764Hess Alex · American Fork, UTBuilt 1974 · S/N 28-7505008N4476VDirty Bird Helicopters LLC · Boerne, TXBuilt 2012 · S/N 4551N4476WBmg Aviation Leasing LLC · Bloomington, INBuilt 1974 · S/N TC-1809N4476ZS And C Flying LLC · Pierre, SDS/N 18-8827N44771Benedict Kevin M · Lakeland, FLBuilt 1974 · S/N 28-7525003N44772Hanson Donald H · Bellevue, WABuilt 1974 · S/N 28-7515028N44773Nair Vihas G · Philadelphia, PABuilt 1974 · S/N 28-7515029N44775Heuerman Jordan D · Casey, ILBuilt 1974 · S/N 28-7515030N44777Delisi Carl V · Linden, MIS/N 28-7510004N4477ABrown Danny J · Skidmore, MOBuilt 1956 · S/N 18-4833N4477PAirknocker Inc · Wilmington, DEBuilt 1960 · S/N 25-253
Back to AD 2007-04-19 R1