OpenAirDocs.org
AD 2007-07-06 R1

Registered aircraft · 691

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-07-06-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-07-06-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.

N33TPJt Services LLC · Wilmington, DEBuilt 2008 · S/N 411049N343RCHoekstra David A · Roswell, NMBuilt 2007 · S/N 41768N345HBWomack Mark G · Chico, CABuilt 2008 · S/N 421011N347CASouth Bay Air LLC · Romulus, MIS/N 411004N3501SRynearson John L Trustee · Scottsdale, AZBuilt 2006 · S/N 41588N350BLAustin Neal · Fort Myers, FLBuilt 2003 · S/N 42006N350BTAeroventure LLC · Middletown, DEBuilt 2006 · S/N 42537N350CWPrivate Flight LLC · Wilmington, DEBuilt 2006 · S/N 42520N350DGQualitair LLC Trustee · MichelstadtBuilt 2005 · S/N 42074N350FJHafer Randall Frederick · Marietta, GABuilt 2008 · S/N 421008N350JAGriffin Michael · Texarkana, ARS/N 421010N350PGGuerra Michael E · Kerrville, TXBuilt 2003 · S/N 42005N350RPShy Dennis · Cape Coral, FLBuilt 2004 · S/N 42046N350SFTakamatsu Hiroaki · Redmond, WAS/N 42062N350SLNeenair LLC · Danville, VABuilt 2006 · S/N 42526N351KAByrnes Leasing Inc · Wilmington, DEBuilt 2008 · S/N 411095N352JAPeterson Erik · Zeeland, MIBuilt 2008 · S/N 421005N352JSMccormick Kevin · Douglass, TXBuilt 2006 · S/N 42507N356CAWest Road LLC · Whiting, VTS/N 42502N358DMTampa Maule LLC · Tampa, FLBuilt 2006 · S/N 42548N361LBMiller Steven D · Edinburg, PABuilt 2003 · S/N 42010N362JVBeaudoin Denis Roland · Rowlett, TXBuilt 2006 · S/N 41693N364KNo Plans LLC · Alvord, TXBuilt 2007 · S/N 42557N369BWHilliard Richard W · Southern Pines, NCBuilt 2007 · S/N 41791N371BGCzok Justin · Park Ridge, ILBuilt 2005 · S/N 41104N373DFEater Ben · Mountain View, CABuilt 2008 · S/N 411009N376PDStriplin Donald B · Mammoth Lakes, CABuilt 2004 · S/N 41018N378FJSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2003 · S/N 40076N37BAAmbler Robert L · San Diego, CABuilt 2001 · S/N 40020N37SRMeckler Enterprises LLC · Bend, ORBuilt 2008 · S/N 411017N384ADRltw LLC · Scottsdale, AZBuilt 2008 · S/N 411008N385TWSheely Patrick D Trustee · Rapid City, SDS/N 40072N3908ER & S Grant Aero Co LLC · Fraser, MIBuilt 2006 · S/N 41600N397STRegistered aircraftBuilt 2006 · S/N 41706N400AWThomson Roy · New Castle, COS/N 41025N400BATulip Tree Hill LLC · Bloomington, INBuilt 2008 · S/N 411054N400BUAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2008 · S/N 411047N400DRKestrel Merlin LLC · Lambertville, MIBuilt 2007 · S/N 41792N400EAMdts Corp · Eden Prairie, MNBuilt 2008 · S/N 411036N400FALifeline LLC · Jacksonville, ORBuilt 2008 · S/N 411103N400FNPb Management LLC · Montgomery, TXBuilt 2008 · S/N 411011N400HFEastern Stearman Inc Trustee · Leesburg, VABuilt 2006 · S/N 41577N400KCGoldsmith Aero Holdings LLC · Pensacola, FLBuilt 2006 · S/N 41616N400KGDg Aviation LLC · Mansfield, TXBuilt 2008 · S/N 411072N400KHWarren James B · Houston, TXBuilt 2006 · S/N 41598N400KMRegistered aircraftBuilt 2006 · S/N 41604N400LDLa Davis LLC · Strawn, TXBuilt 2005 · S/N 41507N400LPLuitjens Jacob Jelte · Cascade Locks, ORS/N 41512N400LXChartier Michael W · Las Vegas, NVS/N 411137N400MLE Smith LLC · Wilmington, DEBuilt 2008 · S/N 411068
Back to AD 2007-07-06 R1