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.

N329DSWears Peter B · Durham, NCBuilt 2012 · S/N 40.1142N336DSValiair Limited Company Trustee · Casper, WYBuilt 2004 · S/N 40.365N338DSMission Air LLC · North Charleston, SCBuilt 2013 · S/N 40.1180N338MAHayes & Associates Inc · Teays, WVBuilt 2003 · S/N 40.298N33SYFlight Level 510 LLC · El Dorado Hills, CABuilt 2004 · S/N 40.370N342AFMckay Ian · Seattle, WABuilt 2009 · S/N 40.1040N342DSHaynes Gregory P · Opelousas, LAS/N 40042N343AMSkyline Aviation Inc · San Angelo, TXBuilt 2007 · S/N 40.822N343DSStoeppel Anthony · Cynthiana, KYBuilt 2008 · S/N 40.1017N343SGGustafson Scott Lyle · Greenwood Village, COBuilt 2009 · S/N 40.1064N344AFUtah State University · Logan, UTBuilt 2009 · S/N 40.1044N344DSStar Of Africa Capital LLC · Villanova, PABuilt 2008 · S/N 40.1026N344MARomeo Romeo LLC · Lewes, DEBuilt 2003 · S/N 40.344N346DSInternational Air Services Inc Trustee · Carson City, NVBuilt 2009 · S/N 40.1066N349AFSky Safety Inc · San Antonio, TXBuilt 2009 · S/N 40.1059N349DSMiddle Tennessee State University · Murfreesboro, TNBuilt 2010 · S/N 40.1081N34TW34 Tango Whiskey LLC-S · Carmel, INBuilt 2005 · S/N 40.501N350ASSky West Aviation Inc Trustee · Albuquerque, NMBuilt 2003 · S/N 40.343N350RJSkyline Aviation Inc · San Angelo, TXBuilt 2005 · S/N 40.573N352DSWesley Flyers Inc · Madison, MSBuilt 2002 · S/N 40.252N354DSRandhawa Sandeep S · Bedford, NHBuilt 2010 · S/N 40.1082N356DADragonfly Aviation LLC · Winder, GABuilt 2004 · S/N 40.356N362DSKamelia Aviation LLC · Catharpin, VABuilt 2010 · S/N 40.1084N363DSDonkers Dave · Nerstrand, MNBuilt 2003 · S/N 40.303N367USEdic Silva LLC · Monte Sereno, CAS/N 40.846N369JPWaddell Patrick G · Seattle, WABuilt 2003 · S/N 40.310N369KBLowery Ted · Raleigh, NCBuilt 2007 · S/N 40.878N370DCMarcantoni Henry W · Round Rock, TXBuilt 2008 · S/N 40.931N370DSCarrera Group Inc · Glen Cove, NYBuilt 2008 · S/N 40.1019N372SEK2 Aviation LLC · Greenwood Village, COBuilt 2004 · S/N 40.372N376DSNorth Inlet Holdings LLC · Wilmington, DEBuilt 2009 · S/N 40.1032N377DSSeward Bernard L Jr · Charlottesville, VABuilt 2003 · S/N 40.277N378DSMaya Air Services LLC · Lee, NHBuilt 2004 · S/N 40.442N379DSTyrol Holdings LLC · Sheridan, WYBuilt 2008 · S/N 40.923N37NAParker Helicopter LLC · Watsonville, CABuilt 2005 · S/N 40.568N380DSBon Aire Inc · Greenville, SCBuilt 2008 · S/N 40.1015N380PASky Safety Inc · San Antonio, TXBuilt 2004 · S/N 40.380N382KDFive Star Marketing Inc · Raleigh, NCBuilt 2007 · S/N 40.788N383PSUtah State University · Logan, UTBuilt 2006 · S/N 40.FC021N384CAUtah State University · Logan, UTBuilt 2006 · S/N 40.734N384DMVolair Aviation LLC · Waxhaw, NCBuilt 2004 · S/N 40.443N384DSJs Aviation Holdings LLC · Warner Robins, GABuilt 2008 · S/N 40.1037N385DSSt Pete Aviation Services LLC · Saint Petersburg, FLBuilt 2008 · S/N 40.1038N386DSMidwest Corporate Air Inc · Bellefontaine, OHBuilt 2010 · S/N 40.1106N386JPSky Safety Inc · San Antonio, TXS/N 40.386N386MAK2 Aviation LLC · Greenwood Village, COS/N 40.449N387CARegistration Pending · Goldthwaite, TXRegistration pendingBuilt 2007 · S/N 40.810N387DSRone Aviation LLC · Lexington, KYBuilt 2010 · S/N 40.1107N38AMFly N38am LLC · Arcadia, CABuilt 2006 · S/N 40.712N38CFMountain Aviation LLC · Salem, VAS/N 40.567
Back to AD 2007-11-21