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.

N408FLSmith Benson H · Herington, KSBuilt 1971 · S/N 28-7125184N408GHMcdowell Kevin A · Tumwater, WABuilt 1959 · S/N 57075N408HCFarview Holdings LLC · San Francisco, CABuilt 2024 · S/N 1367N408JCN408jc LLC · Scottsdale, AZBuilt 1977 · S/N E-1194N408JMRobinson Wayne D · Highlands Ranch, COBuilt 2000 · S/N 80380N408LBM & G Aircraft Management LLC · Englewood, COBuilt 2012 · S/N 172S11157N408LJHuston Craig C · Keokuk, IABuilt 1975 · S/N 18264147N408LTDecathlon LLC · Lincoln, NEBuilt 2025 · S/N 012N408PBBaich Michael V · Bovey, MNBuilt 1979 · S/N 28-7911143N408PTRegistered aircraftBuilt 1981 · S/N 1N408RStone Aviation LLC · Cusick, WABuilt 1954 · S/N 31149N408RGGould Rod · Milford, IABuilt 2018 · S/N 14183N408ZAlpha Tango Aircraft LLC · Wilmington, DEBuilt 2023 · S/N 2881669N408ZWLinett Michael J · Elsmere, DEBuilt 2019 · S/N 41724N40903Boyer Aviation LLC · Kiel, WIBuilt 1973 · S/N 28-7415108N40904Allred Klein Enterprise LLC · San Diego, CABuilt 1973 · S/N 28-7415109N40905Martin James Christopher · South Jordan, UTBuilt 1973 · S/N 28R-7435140N4090ATop Gun Aviation Group Inc · Santa Monica, CABuilt 1978 · S/N 310R1368N4090EAerodrome LLC · Louisville, KYBuilt 1977 · S/N 18-7809062N4090HSouthern Air Transport Services LLC · Dover, DEBuilt 1969 · S/N 18052083N4090SByerly Brooks · Plano, TXBuilt 1975 · S/N E-645N4091GRobinson Brant Fitzgerald · Powder Springs, GABuilt 1977 · S/N 340A0275N4091PPaulay Sandor F · Kenmore, WABuilt 1959 · S/N 23-1570N4091SBeechcraft Heritage Museum · Tullahoma, TNBuilt 1975 · S/N CE-556N4091ZA G Sholton Co · Wasilla, AKBuilt 1964 · S/N 18-8109N40925High Flight Academy LLC · Allison Park, PABuilt 1973 · S/N 28-7415112N4092TEnnyx LLC · Clermont, FLBuilt 1974 · S/N E-556N40935International Air Services Inc Trustee · Carson City, NVBuilt 1941 · S/N 7603N40936Aerial Sign North Inc · Lakewood, NJBuilt 1941 · S/N 7592N40939Grog Holdings LLC · Dallas, TXBuilt 1973 · S/N 28-7425191N4093DZito Nick D · Ellensburg, WABuilt 1957 · S/N 34793N4093EDmkr LLC · Coronado, CABuilt 1999 · S/N E-3293N4093PLumley John J · Delray Beach, FLBuilt 1959 · S/N 23-1572N4093XBartholomeo Daryl A · Cleveland, OKBuilt 1971 · S/N 5193N40945Mount Eagle Inc · Alexander, ARBuilt 1974 · S/N 28-7405077N4094BClosson Luke E Jr · Valdosta, GABuilt 1975 · S/N 75-30782N4094DManker Lance M · North Platte, NEBuilt 1957 · S/N 34794N4094PShelley Isaac R · Scottsville, VABuilt 1959 · S/N 23-1573N4094S4094s LLC · Holly, MIBuilt 1975 · S/N TC-1840N40951Grant Constance R Trustee · Eaton, INBuilt 1973 · S/N 28-7425193N40953Cws Capital Holdings LLC · Saint Petersburg, FLBuilt 1973 · S/N 28-7415118N4095AValiair Limited Company Trustee · Casper, WYBuilt 1979 · S/N 18503910N4095DRedfern Ronnie M · Fairbanks, AKBuilt 1957 · S/N 34795N4095PTorell Pamela O · Port Saint Lucie, FLBuilt 1959 · S/N 23-1574N4095ZBreidenbach Bros Inc · Iliff, COBuilt 1964 · S/N 18-8108N40963Grant Matthew D · Alvord, TXBuilt 1974 · S/N 28-7415120N40965Portsmouth Flying Club LLC · Epsom, NHBuilt 1973 · S/N 28-7415121N40966Skytech Hc Ltd · Fredericksburg, OHBuilt 1973 · S/N 28-7415122N40967Mcbroom Darrin · Des Moines, IABuilt 1973 · S/N 28R-7435146N40969Papa Bravo LLC · Decatur, ALBuilt 1974 · S/N 28-7410052
Back to AD 2007-04-19 R1