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.

N321HMMusser Harold R · Cody, WYBuilt 2010 · S/N 3109N321HWVan Andel Lambert J Jr · Coopersville, MIBuilt 1998 · S/N 18280264N321JBCox Kevin · Lexington, KYBuilt 1978 · S/N AA5A0560N321JECapital Affairs West LLC · Helena, MTBuilt 2004 · S/N 40.374N321JHSkidmore Gary DBA · Terreton, IDBuilt 1978 · S/N 414A0063N321JJJayjet Private Aircraft Charter LLC · Swanton, OHBuilt 2004 · S/N 1113N321JPAzure Skyes Holdings LLC · Poulsbo, WABuilt 1980 · S/N 18504166N321JRAcademy Aviation Services LLC · Cedar Park, TXBuilt 1982 · S/N EA-289N321JTPcss Aviation LLC · New Albany, MSBuilt 2001 · S/N EA-670N321KJFly-By LLC · Cope, COBuilt 2022 · S/N 12190081N321KKPanoche Aviation Co LLC · Fresno, CABuilt 1979 · S/N 18267488N321KSKingsky Flight Academy LLC · Lakeland, FLBuilt 1982 · S/N 17275853N321LALowair LLC · Lake City, SCBuilt 1978 · S/N 32R-7885178N321LGLaughing Gull Aviation Inc · Fort Lauderdale, FLBuilt 1978 · S/N 21062769N321LMStarkey Mike · Dayton, NVBuilt 2021 · S/N 12180029N321MCAerospace Trust Management LLC Trustee · Wilmington, DES/N 5233N321MECounty Of Henrico Virginia · Henrico, VABuilt 2000 · S/N 172S8566N321MJPetrie David W · Mechanicville, NYBuilt 1976 · S/N M-1850N321MMJohnson Curtis A · St Paul, MNBuilt 1979 · S/N 18503976N321MPAker Carroll Gregory · Titusville, FLBuilt 1991 · S/N 10084N321MTIflyhi Aviation LLC · Sanbornton, NHBuilt 2005 · S/N 1696N321NOatman Scott A · Colorado Springs, COBuilt 1968 · S/N TE-583N321NASanchez David A · San Luis Obispo, CABuilt 2001 · S/N 24650N321NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2024 · S/N 2881748N321PAFosston Flying Club Inc · Fosston, MNBuilt 1971 · S/N 17260202N321PFRrsf LLC · Pleasant Grove, UTBuilt 2004 · S/N 40.375N321PKYaqunda Yousif N · Fallbrook, CABuilt 1994 · S/N PK-1N321PPMathews Aviation LLC · Marysville, CABuilt 1977 · S/N 18265834N321PRChavi LLC · Fredericksburg, TXBuilt 2006 · S/N 11142N321QPelco Aviation Inc · Hampton Bays, NYBuilt 1978 · S/N R18200438N321RBMessmore Micheal Henry · Toledo, WABuilt 1976 · S/N 18052677N321RCHitchen Robin J · Bernardsville, NJBuilt 2013 · S/N 90217N321RHTorrey Daniel B · Ojai, CAS/N 74-30657N321RJGritter Richard J · Catlett, VABuilt 1977 · S/N 323-77N321RPIsrael Oscar M III · Sinton, TXBuilt 1973 · S/N 340-0201N321RR321 Rr Lp · Wimberley, TXBuilt 1968 · S/N TE-520N321RTBarr Air Patrol LLC · Mesquite, TXBuilt 1979 · S/N 189N321RVRegistration Pending · Norton Shores, MIRegistration pendingBuilt 1998 · S/N 20372N321SASedlak Julien · Fort Worth, TXBuilt 1993 · S/N 1251N321SHFish Kenneth I · West Unity, OHBuilt 1976 · S/N 28-7690333N321SKSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2019 · S/N 30050N321SREstler Carlton George · Richmond, TXBuilt 1995 · S/N 3239N321TAAldag Thomas D · Wichita, KSBuilt 2020 · S/N 83171N321TBMob Aviation USA LLC · Auburndale, FLBuilt 1982 · S/N E-1998N321TDDeakyne David J · Wallingford, PABuilt 1992 · S/N DEAKYNE 0001N321TEBerg Orvie E Trustee · Rock Springs, WYBuilt 2001 · S/N 32N321TJCole Warren G · Watkinsville, GABuilt 1976 · S/N 17266807N321TVSky Helicopters Inc · Garland, TXBuilt 2012 · S/N 13262N321VAvia Flight Academy LLC · Stratford, CTBuilt 1968 · S/N 28-4665N321VBYoung Mike · Loop, TXBuilt 1960 · S/N 18-7533
Back to AD 2007-04-19 R1