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.

N1003XKap Electric Inc · Sulphur, LAS/N 41748N10111Psh Leasing LLC · Park City, UTS/N 41739N1018QLambert Brent · Roanoke, VABuilt 2009 · S/N 421018N1019KPreferred Flight Management LLC · Goshen, INBuilt 2008 · S/N 421004N101PMKasper John D · Oxford, ALBuilt 2004 · S/N 42055N10222Willard Gregory M · Bonita Springs, FLBuilt 2009 · S/N 411141N1024ZAqua Men Service LLC · Temple, GABuilt 2005 · S/N 41097N102FPN9817k LLC · Fredericksburg, VABuilt 2006 · S/N 42511N10332Tx Holdings · Hermosa Beach, CABuilt 2009 · S/N 411132N1036PHeyden Aviation LLC · Alpharetta, GABuilt 2009 · S/N 411138N103FPStyle Ventures LLC · Lafayette, LABuilt 2006 · S/N 42512N103PFQuality Protection Inc · Springfield, MOBuilt 2008 · S/N 411092N104FPAutowashlbt LLC · Lumberton, NCBuilt 2006 · S/N 42513N104PPToledo Public Schools · Swanton, OHS/N 41086N10580Dwyer Lawrence William · Berthoud, COS/N 411150N10582Horizon A Dream Inc Trustee · Wilmington, DES/N 411152N1058ZBaillie Richard Leslie · Newark, DEBuilt 2008 · S/N 411058N1087TCampagna Thomas B · Midland, TXBuilt 2008 · S/N 411033N1088DSpf America LLC · Fort Smith, ARBuilt 2009 · S/N 421015N1097LInternational Air Services Inc Owner Trustee · Carson City, NVBuilt 2008 · S/N 421006N1112LGunrunner 15 Air LLC · Hilton Head Island, SCBuilt 2009 · S/N 421017N1131KFirst Properties LLC · Medford, ORBuilt 2007 · S/N 41742N1131VPeter V Desanctis Cpa Pa · Jupiter, FLBuilt 2008 · S/N 411098N1133GGrannell Roy B · Southlake, TXBuilt 2009 · S/N 411126N1134NFls LLC · Missoula, MTBuilt 2009 · S/N 411134N1137ASleepwalker Aviation LLC · Wilmington, DES/N 42567N11390Young Randy Jay · Spanish Fork, UTBuilt 2009 · S/N 411139N113FPPrice Ricardo Andres · Granbury, TXBuilt 2007 · S/N 42546N1141YHeyde Robert D · Coeur D Alene, IDBuilt 2009 · S/N 411140N1143ZVoov LLC · Dover, DEBuilt 2008 · S/N 411107N1159QPeak Aviation LLC · Salida, COBuilt 2008 · S/N 411061N115FPBas Part Sales LLC · Greeley, COBuilt 2007 · S/N 42552N1161VDesert Pine Aviation LLC · Scottsdale, AZS/N 41749N116FTGreenhill Stacey · Lincolnshire, ILBuilt 2008 · S/N 411112N1170BHooper Jonathan · Andrews, NCS/N 42563N117FPCross Timbers Holdings LLC · Dover, DEBuilt 2007 · S/N 42553N1198ZExecutive Airfleet LLC · Boca Raton, FLS/N 411151N119PEDoo Me Too LLC · Spearfish, SDS/N 411043N1211DWest Ridge Ttx LLC · Parker, TXBuilt 2008 · S/N 411104N1213MOlson Sandra K · Edmonds, WABuilt 2006 · S/N 42543N121TBRecovery Room LLC · Smyrna, GABuilt 2006 · S/N 42540N1222GNational Aerotech Aviation Delaware Inc · Wilmington, DES/N 42554N1229VSale Reported · Greeley, COSale reportedBuilt 2008 · S/N 411110N1235LN1235l LLC · Tallahassee, FLBuilt 2007 · S/N 41741N1239ZDerrickson Bryan C · Lewes, DEBuilt 2009 · S/N 411124N1241GCastanon Mike · Perryton, TXBuilt 2007 · S/N 41777N1243XAircraft Partner Holdings Inc Trustee · BerlinBuilt 2007 · S/N 41755N1253YSallee Real Estate Investments LLC · Lees Summit, MOBuilt 2009 · S/N 411133N125BTPointe Companies Inc · Silver City, NMBuilt 2009 · S/N 411125N1266PArnold Aviation Ltd · Minster, OHBuilt 2006 · S/N 41637
Back to AD 2007-07-06 R1