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.

N409RCrawford Russell W · Hurricane, UTS/N D-6011N409RWAllred Mike · Thomasville, NCBuilt 2012 · S/N RWW-3N409SHSky Solutions LLC · Westland, MIBuilt 2008 · S/N 12409N409SJKirsh & Kirsh P C · Indianapolis, INBuilt 2005 · S/N 42084N409SSBlackwell Aviation Inc · Bell Vernon, PABuilt 1965 · S/N D-7952N409TPParagon Airplane Leasing Co · Fort Myers, FLBuilt 2022 · S/N 28020073N409VRegistered aircraftBuilt 1965 · S/N TE-7N409XDunn Blake · Bristol, COBuilt 1976 · S/N 7043CN409XXPope James D · Clarkston, WABuilt 2013 · S/N 001N40ABSchumacher Steven Joseph · Fayetteville, ARBuilt 1983 · S/N CE-1020N40ACRadecki Louis · Helenville, WIBuilt 1991 · S/N 644-91N40AESchwartz Michael · Missoula, MTBuilt 1964 · S/N 18255664N40ASSchaad Rene · Arroyo Grande, CABuilt 1998 · S/N 18280422N40ATN40at LLC · Lewis Center, OHBuilt 1978 · S/N R18200527N40AWKlingbeil Mark T · Bottineau, NDBuilt 1999 · S/N 1452N40BBPawlak Jakub Piotr · Lafayette, INBuilt 1977 · S/N 18265944N40BLK & B Real Estate Holdings LLC · Huntley, MTS/N 18264088N40BXBreton Michael A · Avon Lake, OHBuilt 2004 · S/N 25771N40BYMassengill Brad · Lowell, INBuilt 2012 · S/N 91232N40CBBurnett Chad H · Draper, UTBuilt 1996 · S/N 22105N40CFG&M Flyers LLC · Wilmington, DEBuilt 1998 · S/N 29-0136N40CKDcy Aviation Group LLC · Linton, INBuilt 1977 · S/N 17269264N40CMKline Timothy L · Elverson, PABuilt 1987 · S/N 368N40CRMoyer Gregg A · Haymarket, VABuilt 2015 · S/N 1003N40CSSoloy L Chris · Wasilla, AKBuilt 1993 · S/N 1N40CZBeast Aero Consulting And Training LLC · Rosamond, CAS/N 0763N40DACirrus Design Corp · Duluth, MNBuilt 1965 · S/N 30-904N40DCWright Innovators LLC · Sebastian, FLBuilt 1988 · S/N 561N40DLStyer David B · Pendleton, ORBuilt 1971 · S/N 071N40DRRoss David R · Wakeman, OHBuilt 1991 · S/N DR-01N40DZSt. Bernard Aerial LLC · Kalispell, MTBuilt 1947 · S/N 12-2675N40ECHill Richard C · Buckeye, AZS/N 18256692N40EHHibler Phillip E · Alameda, CABuilt 1995 · S/N 2067N40EMYour Moms Upset LLC · Saint Paul, MNS/N 696-92N40ERFlying Aces Aero Fleet Inc · Guyton, GABuilt 1977 · S/N 17269569N40ESP.C. Air LLC · Lockport, NYBuilt 2008 · S/N 71432N40FAWright Paul G Trustee · Scotts Valley, CABuilt 1972 · S/N AA5-0114N40GHagerty Environmental LLC · Kennett Square, PABuilt 1972 · S/N D-9342N40GBSlb Enterprises LLC · Newark, DEBuilt 1977 · S/N 340A0264N40GDSimply Living LLC · Fort Myers, FLBuilt 2003 · S/N 0473N40GECuckler Dale E · Tulsa, OKBuilt 1998 · S/N 1545N40GMSteven E Cox · Bend, ORBuilt 1964 · S/N D-7343N40GRPetao LLC · Trinity, FLBuilt 2003 · S/N 21980N40GVHauser Paul J · Longmont, COBuilt 1976 · S/N U20603438N40HFVogel Essex Nathaniel B · Berkeley, CAS/N 15072309N40HUMoore Charles B · Miles City, MTBuilt 1996 · S/N 1315N40HYHendrickson Dale W · Denton, TXBuilt 2002 · S/N 2205N40JTav8rs LLC · Tea, SDS/N 001N40JAJersey Aero Club Inc · Lakewood, NJBuilt 1985 · S/N 28-8616036N40JBElk River Aero LLC · Noel, MOS/N TH-338
Back to AD 2007-04-19 R1