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.

N1266YVerona Equipment LLC · Verona, KYBuilt 2006 · S/N 41587N1267JN703fb Corp Trustee · Wilmington, DEBuilt 2007 · S/N 42509N1268FTilted Wings LLC · Manassas, VABuilt 2006 · S/N 41648N1268RAyres Robert Paul · Okeechobee, FLBuilt 2006 · S/N 42530N1269DMckeage Bradley J · Melbourne, FLBuilt 2006 · S/N 41633N1269EDestin Operating Co Inc · Lafayette, LABuilt 2006 · S/N 42522N1271BVan Dyck Philip · Athens, GAS/N 42529N1271T3dg LLC · Sylva, NCBuilt 2006 · S/N 41655N12727Sunset Spas LLC · Chandler, AZBuilt 2007 · S/N 41769N1272NEastern Stearman Inc Trustee · Leesburg, VABuilt 2007 · S/N 41650N12744Esa Es Corp · Glen Cove, NYBuilt 2006 · S/N 41690N1274AAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2007 · S/N 41762N1274XFly El Paso LLC · El Paso, TXBuilt 2008 · S/N 411077N1276LD Porter Enterprises LLC · Dickinson, NDBuilt 2006 · S/N 41651N1276ZJrjhnj Aviation LLC · Statesboro, GABuilt 2009 · S/N 411120N1278DRegistered aircraftBuilt 2007 · S/N 42532N1278ZNew Hartford Psychiatric Services P L L C · Whitesboro, NYBuilt 2006 · S/N 41658N127DRKlamecki Alan P · Phoenix, AZBuilt 2001 · S/N 40028N1280ZPlane Fun Inc Tr Trustee · Snellville, GABuilt 2007 · S/N 41654N1282DJas & Jls Holdings LLC · Lake Point, UTBuilt 2006 · S/N 41642N1282MCastaneda Carlos · Clyde Hill, WABuilt 2008 · S/N 411083N1285D6886 Aviation LLC · Mesa, AZS/N 41638N1285VCarrobby LLC · Wilmington, DEBuilt 2008 · S/N 411085N1286CCalabarb Aviation LLC · Mesa, AZBuilt 2006 · S/N 41591N1287DRcad LLC · Wilmington, DEBuilt 2009 · S/N 411144N1288NTextron Aviation Inc · Wichita, KSBuilt 2008 · S/N 411088N1291NWestern States Liquefied Petroleum Gas Co · Elko, NVBuilt 2009 · S/N 411128N1294PBagdasarian Walter DBA · El Cajon, CABuilt 2006 · S/N 41660N1295JN1295j Corp Trustee · Wilmington, DEBuilt 2006 · S/N 41641N1297EWood Paul Richard · Cumming, GABuilt 2008 · S/N 411097N1298GMango Tango Air LLC · Cantonment, FLBuilt 2007 · S/N 42533N1299HB&C Aviation LLC · Helena, MTBuilt 2008 · S/N 411099N1299KOrange And Black LLC · Lewes, DEBuilt 2008 · S/N 411062N12XYShramek Troy · Bossier City, LABuilt 2007 · S/N 42545N1302CFun Flying LLC · Granbury, TXBuilt 2006 · S/N 41632N1308LQualitair LLC · MichelstadtBuilt 2006 · S/N 41590N13106Diamond J Aviation LLC · Greensboro, NCBuilt 2008 · S/N 411106N1310MN1310m LLC · Palmyra, VABuilt 2006 · S/N 41678N131MWFarina George · Killen, ALBuilt 2004 · S/N 41021N1321CClark Charles G · Catlettsburg, KYBuilt 2006 · S/N 42517N1324QTechnoflight LLC · Verona, WIBuilt 2006 · S/N 41686N1327GRk Air LLC · Shreve, OHBuilt 2006 · S/N 41689N13331Cjc Aviation Inc Trustee · Wilmington, DEBuilt 2006 · S/N 42528N1334XGiannetti Nicholas · Charlotte, NCBuilt 2007 · S/N 42510N1340MValiair Lc Trustee · Casper, WYBuilt 2006 · S/N 41666N1345NHolco Solutions LLC · Wilmington, DEBuilt 2007 · S/N 41784N1355CC&E Aviation LLC · Kalispell, MTBuilt 2006 · S/N 41599N135TTAircruise LLC · Hobbs, NMBuilt 2010 · S/N 411158N1362TKcon Airplane LLC · Kalispell, MTS/N 41789N1364NK & K Adventures · Wilmington, DEBuilt 2006 · S/N 41687
Back to AD 2007-07-06 R1