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.

N320PSCtaerocraft LLC · Lexington, NCBuilt 1996 · S/N 5342N320RKegin Kevin M · Salem, ILBuilt 1992 · S/N 1N320RBLogan David J · Saint Helens, ORBuilt 1963 · S/N 27-2389N320RCEastern Properties LLC · Burlington, NJBuilt 2004 · S/N 18281352N320RMRd Harrison Inc · Lexington, NCS/N 340A0939N320RPRoss Timothy D · Sunbury, PABuilt 2000 · S/N 690N320RRHighway Aero LLC · Bristow, VABuilt 2002 · S/N 0358N320RSSpace Roy D · Windsor, COBuilt 2009 · S/N 439-320-189-FBN320RVVan Dyke Stewart D · Carmel, INBuilt 1999 · S/N 24652N320SSinclair William Robert · Lafayette, CABuilt 2000 · S/N 368-320-124-14PN320SCEcho Aviation LLC · Oregon City, ORBuilt 2025 · S/N 172S13352N320SHMoore Michael C · Anchorage, AKBuilt 1956 · S/N 185060N320SKDevries James E · Bejou, MNBuilt 1967 · S/N 320E-0077N320SLHelmuth Jesse N · Willow, AKS/N 03206N320SPLundstrom Aviation LLC · Ankeny, IABuilt 2003 · S/N 172S9490N320STGuaglione Anthony · El Dorado Hills, CABuilt 2006 · S/N S-10002N320SWEast West Investment Advisors LLC · Sandy Point, VABuilt 1980 · S/N 414A0451N320TDHalvorson Scott B · Fremont, WIBuilt 2025 · S/N 07200125N320THN63e LLC · Fallon, NVBuilt 1996 · S/N 225N320TJBlaylock Arthur S III · Pace, FLBuilt 1963 · S/N 320B0017N320UBoard Of Regents Of The University Of Oklahoma · Norman, OKBuilt 2025 · S/N 28020227N320WWatson R Samuel · Hartsville, SCBuilt 1996 · S/N 1001AN320WDAt Liberty LLC · Apple Valley, MNBuilt 1974 · S/N TH-426N320WSLamb Phillip D · Odessa, MOBuilt 1995 · S/N 1298N320XPBoggs Larry Joseph · Westfield, INBuilt 2023 · S/N 82249N320ZPrzestrzelski John M · Frankfort, NYBuilt 2021 · S/N 11000N32101Speed Hunter Aviation LLC · Franklin, OHBuilt 1974 · S/N 28-7505024N32103Freeman David B · Liberty, NCS/N 28-7505026N3210PKilcullen Brian DBA · Fort Lauderdale, FLBuilt 1978 · S/N P21000027N3210SGore Range Aviators LLC · Kremmling, COBuilt 1964 · S/N 18255710N3210UHaas Todd · Pecatonica, ILBuilt 1963 · S/N 18254610N3210YBergren William · Des Moines, IABuilt 1962 · S/N 18254210N32115Kowatra Anil K · Lilburn, GAFirst renewal noticeBuilt 1974 · S/N 28-7505027N3211DNielson Donald L · Independence, ORBuilt 1955 · S/N 32009N3211EApm Leasing LLC · Casper, WYBuilt 1978 · S/N 17271470N3211LPrevost Bryan · Lambert, MTBuilt 1976 · S/N D-9914N3211PJudie Bear Air LLC · Bend, ORFirst renewal noticeBuilt 1957 · S/N 23-1152N3211QGth Capital LLC · Phoenix, AZBuilt 2014 · S/N 36002CN3211SNoble Tom R · Winnsboro, TXBuilt 1964 · S/N 18255711N3211YFour M Properties LLC · Prague, OKBuilt 1962 · S/N 18254211N32123Kell Matthew D · Kodiak, AKBuilt 1974 · S/N 28-7515076N32124Howard John D · Palm Bay, FLBuilt 1974 · S/N 28-7515077N32128David William Christy Trustee · Willis, TXBuilt 1974 · S/N 28-7505028N32129Weaver Arnold G · Sandusky, MIS/N 28R-7535028N3212DHalo Aviation Corp · Wilmington, DES/N EA-651N3212FMcdonald Ronald W · Olive Branch, MSBuilt 1967 · S/N 670005N3212GGibby Aviation Inc · Wilmington, DEBuilt 1994 · S/N EA-569N3212MKietzer Farms LLC · Wilmington, DEBuilt 1991 · S/N CE-1552N3212QBrighters David E Trustee · Baton Rouge, LABuilt 1977 · S/N 28-7790443N3212TRichmond Timothy R · Deland, FLBuilt 1967 · S/N 17700512
Back to AD 2007-04-19 R1