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.

N47GFGlobal Flight Support And Sales Inc · Tampa, FLBuilt 1997 · S/N 17280161N47HBSparks John Jr · Orange Beach, ALBuilt 1961 · S/N CD-392N47HJWhite Billy C · Baker, FLBuilt 1987 · S/N 476N47HYJoseph C Thomas · Lenoir, NCBuilt 2000 · S/N 2054N47JBBean Jackson A · Quinlan, TXBuilt 1998 · S/N E3207N47JEHurley Nicholas John · Trinity, NCBuilt 1977 · S/N 32R-7780532N47JGCorcoran Peter A · Fallbrook, CABuilt 1976 · S/N 47N47JLElliott David Robert · San Jose, CABuilt 1996 · S/N 3923N47JQJaquish William E · Tunkhannock, PABuilt 2003 · S/N 2109N47JTM & M Investments Of Jonesboro LLC · Jonesboro, ARBuilt 1973 · S/N D-9432N47KABroom John F · Sherman, TXBuilt 1974 · S/N E-530N47KKHermansen Dane K · Ormond Beach, FLBuilt 1983 · S/N T30300216N47KSReiland Daniel E · Spring Valley, MNBuilt 1967 · S/N 18258363N47LMelugin Michael R · Manteo, NCBuilt 1977 · S/N 0770N47LHPompano Senior Squadron Flying Club Inc · Pompano Beach, FLBuilt 1979 · S/N 28-7990480N47LLSmith Roy H · Garberville, CABuilt 1947 · S/N D-972N47LULetourneau University · Longview, TXBuilt 2017 · S/N 4496416N47MDBrambles Inc · Bakersfield, CABuilt 1977 · S/N 414-0945N47MEN47me LLC · Tampa, FLBuilt 1981 · S/N 6008848161250N47MKAztec Aviation Two LLC · Augusta, GABuilt 1973 · S/N 27-7305122N47MLWitt Jerry D III · Houston, TXBuilt 1956 · S/N 22-3865N47NFAndrews University · Berrien Springs, MIS/N 60-6047N47NLAnton Billy V · Satanta, KSBuilt 2018 · S/N 135BN47NZFish Dwain E · Silver Springs, NVS/N 1947N47PGRandall Skye Sanjay · Lansdowne, PABuilt 1977 · S/N AA5A0340N47PHReal Time Aviation LLC · Southlake, TXBuilt 2016 · S/N TH-2467N47PLGreer Wesley E · Woodstock, GABuilt 2008 · S/N 72157N47PSPalm Springs Air Museum Inc · Palm Springs, CABuilt 1973 · S/N 18262767N47RGGossard Philip G · Stonington, MEBuilt 1994 · S/N 3290N47RTBas Part Sales LLC · Greeley, COBuilt 1997 · S/N E-3142N47RWSale Reported · Glen Allen, VASale reportedS/N 35088N47SSandlapper Aviation Of De Inc · Bennington, VTBuilt 1970 · S/N 28R-35769N47SDWampler William C · Canton, TXS/N 108-0989N47SPDurham Rex L · Blakely, GABuilt 1969 · S/N 310P0176N47SRRendezvous T82 LLC · Mansfield, TXS/N 1418N47STFuhs Nicholas J · Advance, NCS/N 2739N47TCWright Frank David · Sequin, TXBuilt 1975 · S/N 21061028N47TDBeene Donald · Westfield, INBuilt 1999 · S/N 60023N47TGTan Industries LLC · Wilmington, DEBuilt 1980 · S/N TC-2343N47TLObendorf Phillip G · Parma, IDBuilt 1976 · S/N 18503185N47TNFlight Operations Aircraft LLC · Wilmington, DEBuilt 2005 · S/N 172S9996N47TSStewart Terry · Anchorage, AKBuilt 1977 · S/N 18-7709120N47TWRiley Steven M · Bucyrus, KSBuilt 2026 · S/N 0005611N47TZZilka Timothy R · Alpine, WYBuilt 1977 · S/N 18265448N47UAleco 182 LLC · Vestavia Hills, ALBuilt 1980 · S/N R18201525N47UTHogan Robert Wayne · Gainesville, TXBuilt 2008 · S/N 18102CN47VMCox Michael · Casper, WYBuilt 2023 · S/N 634-2023N47WCFly Girls Aviation LLC · Saint Amant, LABuilt 1959 · S/N TD-241N47WK57 Bw LLC · Reno, NVBuilt 2007 · S/N TH-2179N47WLSchettler Patrick J · Garnett, KSBuilt 2001 · S/N MM001
Back to AD 2007-04-19 R1