OpenAirDocs.org
AD 2007-11-21

Registered aircraft · 702

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-11-21')
    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-11-21')
  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.

N100UVJohn B Bateman · Draper, UTBuilt 2004 · S/N 40.405N101JPKrouse Donald E · Weaverville, CABuilt 2002 · S/N 40.218N102UVFrequency Change Aviation Services Inc · Nashville, TNBuilt 2005 · S/N 40.549N103UVUtah Valley University · Orem, UTBuilt 2006 · S/N 40.683N104JASkywest Leasing Inc · Saint George, UTBuilt 2004 · S/N 40.440N104UVUtah Valley University · Orem, UTBuilt 2006 · S/N 40.684N105UVUtah Valley University · Orem, UTBuilt 2006 · S/N 40.685N106UVUtah Valley University · Orem, UTBuilt 2006 · S/N 40.686N107KCRandall Frederick Kuchenmeister · New Baltimore, MIBuilt 2011 · S/N 40.1126N107UVUtah Valley University · Orem, UTBuilt 2009 · S/N 40.1030N108CFCentral Flying Service LLC · Little Rock, ARBuilt 2005 · S/N 40.479N108UVUtah Valley University · Orem, UTBuilt 2003 · S/N 40.342N109UVUtah Valley University · Orem, UTBuilt 2020 · S/N 40.1214N110UVUtah Valley University · Orem, UTBuilt 2020 · S/N 40.1216N112UVUtah Valley University · Orem, UTBuilt 2020 · S/N 40.1217N113SDCavu Pilot LLC · Powell, TNBuilt 2008 · S/N 40.1011N113UVUtah Valley University · Orem, UTBuilt 2020 · S/N 40.1218N114UVUtah Vallet University · Orem, UTBuilt 2020 · S/N 40.1221N115UVUtah Valley University · Orem, UTBuilt 2020 · S/N 40.1222N116UVUtah Valley University · Orem, UTBuilt 2020 · S/N 40.1223N118GMUtah State University · Logan, UTBuilt 2005 · S/N 40.521N118UVUtah Valley University · Orem, UTBuilt 2020 · S/N 40.1224N119UVUtah Valley University · Orem, UTBuilt 2020 · S/N 40.1225N11ZMJr Aircraft Services LLC · Oxford, MIBuilt 2004 · S/N 40.460N120DSElement Aero LLC · Chicago, ILBuilt 2002 · S/N 40.220N121CJCharlie Juliet Aerospace LLC · Naugatuck, CTBuilt 2005 · S/N 40.466N123MZMj Aviators LLC · Portland, ORBuilt 2010 · S/N 40.1070N123NADecker Family Aviation LLC · Conroe, TXBuilt 2005 · S/N 40.484N123TVIn Flight Aircraft LLC · Howell, MIBuilt 2004 · S/N 40.432N1244TMiddle Tennessee State University · Murfreesboro, TNBuilt 2015 · S/N 40.1191N125HAK-14 Squadron LLC · Santa Fe, NMBuilt 2004 · S/N 40.416N125HLRnrnp Holdings LLC · Denton, TXBuilt 2005 · S/N 40.551N126USBraun Darren S · Genoa, NVBuilt 2007 · S/N 40.826N127KCUtah State University · Logan, UTBuilt 2011 · S/N 40.1127N127XKilgore Sky LLC · Parker, AZBuilt 2004 · S/N 40.438N128USPacific Diamond LLC · Moraga, CABuilt 2006 · S/N 40.728N132DSManrin Aviation LLC · Dublin, CABuilt 2004 · S/N 40.450N134PSBountiful Flight LLC · Woods Cross, UTBuilt 2004 · S/N 40.407N135LANryk Air LLC · Greenville, NCBuilt 2022 · S/N 40.1233N136DSHemisphere Dancer LLC · Fripp Island, SCS/N 40.455N136NGuthrie Richard D · San Clemente, CABuilt 2012 · S/N 40.1156N137KCErmg-1 Holdings LLC · Coral Springs, FLBuilt 2011 · S/N 40.1130N138DSLance Murray Aviation LLC · San Marcos, CABuilt 2002 · S/N 40.238N139PSIn-Site Aviation LLC · American Fork, UTBuilt 2005 · S/N 40.518N13DAD&J Training Planes LLC · Logan, UTBuilt 2020 · S/N 40.1210N141HLSynchronistic Operations Solutions LLC · Richmond, VABuilt 2010 · S/N 40.1079N143TJFlying J Aero LLC · Hinsdale, ILBuilt 2005 · S/N 40.591N146JPMartin John A · Grand Prairie, TXBuilt 2005 · S/N 40.481N146TSMile-High Enterprises LLC · Wilmington, DEBuilt 2008 · S/N 40.970N150PTAlchin Aviation LLC · Durand, MIBuilt 2005 · S/N 40.468
Back to AD 2007-11-21