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.

N240CAN240ca LLC · Wilmington, DEBuilt 2010 · S/N 411159N241BSAdventure Airways LLC · Sacramento, CABuilt 2008 · S/N 421014N241EBUsd Flyers Inc · Atlanta, GABuilt 2005 · S/N 42065N241GBPalmer Levi S · Upper Lake, CABuilt 2003 · S/N 42023N242GAT & T Aviation LLC · Paducah, KYBuilt 2007 · S/N 42561N242PZFennell Louis A Jr · Johns Island, SCS/N 40037N244DOlympia Hangars LLC · Tumwater, WABuilt 2005 · S/N 41096N244MWRamba Consulting Group LLC · Tallahassee, FLBuilt 2006 · S/N 41682N244SCGiacometto John · Stevensville, MTBuilt 2004 · S/N 42047N245DBVangundy R Eric · Chapin, ILBuilt 2005 · S/N 41102N247DMGrimmett Lester · Clinton, MSBuilt 2005 · S/N 41506N247MCGray Gary Mario DBA · Tampa, FLBuilt 2008 · S/N 411060N248APRegistered aircraftBuilt 2006 · S/N 42541N24PYMl Aero Inc Trustee · Wilmington, DEBuilt 2007 · S/N 42568N2500TJ & C Holdings Inc · Laguna Beach, CABuilt 2004 · S/N 41026N2502QMaxim Aviation LLC · Sugarloaf Key, FLBuilt 2005 · S/N 42076N2504TColumbia N2504t LLC · North Easton, MABuilt 2006 · S/N 41575N2505JHarrah Enterprises LLC · Cornelius, NCBuilt 2006 · S/N 41576N2506VLancestrom LLC · Tomball, TXS/N 42067N2507LSimply Southern N2507l LLC · Fayetteville, GABuilt 2005 · S/N 41106N2507SFriedman Jeffrey C Trustee · Oakland, CAS/N 41567N2509WDouble D'S LLC · Massillon, OHBuilt 2005 · S/N 41061N2510YMiller Aviation LLC · Sedona, AZS/N 41572N2511GVan Bortel Aircraft Inc · Arlington, TXBuilt 2005 · S/N 41101N2511XAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2005 · S/N 42063N2511YPrieur Philip · Suwanee, GABuilt 2005 · S/N 41060N2512XKeesee Theodore A · Lavonia, GABuilt 2005 · S/N 42077N2514FVan Bortel Aircraft Inc · Arlington, TXBuilt 2005 · S/N 41093N2515BIndependent Columbia Aviators LLC · Katonah, NYBuilt 2004 · S/N 41040N2515QHackney Joel · Trabuco Canyon, CABuilt 2006 · S/N 41585N2516SCol4 Training LLC · Wichita, KSBuilt 2006 · S/N 41570N2517XBraun Robert M Trustee · Watkins, MNBuilt 2005 · S/N 42081N2518HHakan Michael · Carpinteria, CABuilt 2005 · S/N 41079N251DXFlight Advantage Inc · Hot Springs, ARBuilt 2005 · S/N 41068N2520CKrause Douglas R · Hinckley, OHBuilt 2005 · S/N 41516N2520SPeregrine Air LLC · Colorado Springs, COBuilt 2005 · S/N 41073N2521WPc Enterprise Holdings LLC · Penfield, NYBuilt 2005 · S/N 41514N2522FGentrius LLC · Austin, TXS/N 41049N2522SEagleray Design LLC · Burlington, VTS/N 41083N2524GTgc Aviation LLC · Houston, TXBuilt 2005 · S/N 41515N2526BTimd Group USA Inc · Cheyenne, WYBuilt 2005 · S/N 41105N2526LQuest Aero LLC · Zeeland, MIBuilt 2004 · S/N 41035N2527ZQualitair LLC Trustee · MichelstadtBuilt 2005 · S/N 41502N25281Relair LLC · Conesus, NYBuilt 2005 · S/N 41088N2528DOlson Michael S · Ellsworth, KSBuilt 2005 · S/N 41523N2528TN2528t LLC · Norcross, GABuilt 2004 · S/N 41029N2528ZRothermel Aviation LLC · Klingerstown, PAS/N 41055N2529PMatera Management LLC · Spanish Fork, UTBuilt 2005 · S/N 41521N2533KDomicile Capital LLC · Monterey, CABuilt 2005 · S/N 41531N2535LK & L Adventures LLC · Moses Lake, WABuilt 2005 · S/N 41082
Back to AD 2007-07-06 R1