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.

N47WTDoucet Lucius J III · Baton Rouge, LABuilt 1966 · S/N D-8217N47WWLake Shore Aircraft Holdings LLC · Wurtsboro, NYBuilt 2011 · S/N E-3963N47WZPengilly Sky LLC · Ellicottville, NYBuilt 1975 · S/N 18263911N47ZRZira 2x Alw LLC · College Place, WAFirst renewal noticeBuilt 1968 · S/N 28-4974N48007White Andrew Kyle · San Diego, CABuilt 2003 · S/N 5497-01N4800B310 LLC · Auburn, WABuilt 1955 · S/N 35100N4800HBellings Jerry A · Neshkoro, WIBuilt 1972 · S/N 18261310N4800LFlying Aces LLC · Scappoose, ORBuilt 1967 · S/N 28-4139N4800PFun Country Soaring · Avon Lake, OHBuilt 1968 · S/N 25-4580N4800QVan Bortel Inc · Victor, NYBuilt 1978 · S/N 18503562N4800SWaalewyn Tracy W · Clermont, FLBuilt 1969 · S/N 32-1185N4800UWest Michigan Flying Club Inc · Norton Shores, MIBuilt 1963 · S/N 205-0500N4800VRegistered aircraftBuilt 1980 · S/N 172RG0382N4801GFrederick Aero Development Inc · Murrieta, CAS/N 17273349N4801LWilliams Fire Apparatus Inc · Ashland, ALBuilt 1967 · S/N 28-4140N4801NBrentco Aerial Patrol Inc · Canton, OHBuilt 1979 · S/N 18267378N4801PMullens James P · Rogers, ARS/N P21000113N4801UMoore Douglas R · Sylvania, GABuilt 1963 · S/N 205-0501N4802Chambers Ronald E · Fort Collins, COBuilt 1978 · S/N 18053017N4802BJilek Ray A · Spearfish, SDBuilt 1954 · S/N 31600N4802DCentral Pennsylvania Soaring Association Inc · Lemont, PABuilt 1958 · S/N 34902N4802JSwaz Aviation LLC · Mesa, AZBuilt 1968 · S/N 28R-30603N4802LKrishna Vijay · Appleton, WIBuilt 1967 · S/N 28-4141N4802NCentral Oregon Aviation Partners LLC · Bend, ORBuilt 1979 · S/N 18267379N4802TSmith Terry G · Kamuela, HIS/N 28R-7235111N4802UBlue Sky Aviation LLC · Sherwood, ORBuilt 1963 · S/N 205-0502N4802VWilcox Chad R · Muncy Valley, PAFirst renewal noticeBuilt 1967 · S/N 30082N4802ZHoffman James R · Bethel, AKBuilt 1962 · S/N 18-7800N4803Molek Jon · Warren, OHS/N 1126N4803EC180 Holdings LLC · Austin, TXS/N 18052033N4803FNorman Howard A · Freeport, ILBuilt 1976 · S/N 28-7715067N4803GAarow Aircraft Leasing LLC · Mcminnville, ORBuilt 1979 · S/N 17273351N4803KBarker Shawn A · St Maries, IDBuilt 1979 · S/N P21000326N4803LJc And Co Menswear Inc · Tulsa, OKS/N 28-4142N4803PKcn Aero Club Inc · Overland Park, KSBuilt 1967 · S/N CE-111N4803QBruntz Leslie H · Oxford, NEBuilt 1976 · S/N 18802541TN4803SEsmailka Harold E · Ruby, AKBuilt 1969 · S/N 32-1188N4803TValiair Lc Trustee · Casper, WYBuilt 1981 · S/N R18201770N4803WRollins Brian D · Smithville, MSS/N 18268203N4804Pixel King 01 LLC · Fort Worth, TXBuilt 1983 · S/N 18268321N4804AMakely Abraham M · Culpeper, VABuilt 1956 · S/N 22-3956N4804EPrestar Inc · Davis, CABuilt 1978 · S/N 17271665N4804JPetges Nicholas A · Saint Louis, MOBuilt 1967 · S/N CE-122N4804NMueller Scott · Somis, CABuilt 1979 · S/N 18267380N4805GTidewater Flying Club Inc · Newport News, VABuilt 1979 · S/N 17273353N4805KH & M Aviation LLC · Hamilton, OHBuilt 1979 · S/N P21000327N4805LPrunty Gregory A · Saint Peter, MNBuilt 1967 · S/N 28-4144N4805URice Gary B · College Place, WABuilt 1963 · S/N 205-0505N4805VBudulas Peter Panagiotis · Laurel, MDBuilt 1980 · S/N 172RG0384N48061Olsen Mark G Trustee · Ketchikan, AKBuilt 1966 · S/N 185-1084
Back to AD 2007-04-19 R1