OpenAirDocs.org
AD 2012-25-07

Registered aircraft · 251

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:2012-25-07')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2012-25-07')
  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.

N265SHSea Hunt Boat Mfg Co Inc · Sumter, SCBuilt 2013 · S/N 4290N275MSkyknight LLC · Greeneville, TNBuilt 2006 · S/N 4048N28ADBlue Collar Inc · New York, NYBuilt 2013 · S/N 4284N294DLTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2008 · S/N 4138N2DFSuburban Properties 3 LLC · Birmingham, MIS/N 4096N305GPTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2007 · S/N 4106N318DCTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2011 · S/N 4229N31BGGsbg Asset Holdings LLC · Atlanta, GABuilt 2011 · S/N 4243N320JMBlaise Carolina LLC · Wilmington, DEBuilt 2005 · S/N 4035N323MKMkre Equipment LLC · Coral Gables, FLBuilt 2007 · S/N 4077N329HFHr Leasing LLC · Dover, DEBuilt 2007 · S/N 4108N32TMJmt II LLC · Glenview, ILS/N 4196N339ETTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2013 · S/N 4295N33LVMd Air LLC · Wilmington, DEBuilt 2014 · S/N 4316N350GDGulfstream Leasing LLC · Savannah, GABuilt 2005 · S/N 4023N35DMArcadian Leasing LLC · Gary, INBuilt 2011 · S/N 4231N360BEPotomac Air LLC · Bethesda, MDBuilt 2006 · S/N 4054N369GAGulfstream Aerospace Corp · Savannah, GAS/N 4369N370GAGulfstream Aerospace Corp · Savannah, GAS/N 4370N37JLLeprino Foods Co · Denver, COBuilt 2009 · S/N 4162N383KKWestern Devcon Inc · San Diego, CABuilt 2012 · S/N 4252N401JETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2013 · S/N 4286N401SRGulfstream Leasing LLC · Savannah, GAFirst renewal noticeBuilt 2003 · S/N 4001N402JETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2012 · S/N 4266N407DWP A T Productions Aviation LLC · Severna Park, MDBuilt 2006 · S/N 4050N411LLGlen Hill Sky LLC · Oakbrook Terrace, ILBuilt 2015 · S/N 4329N412TJ400tj Inc · Newport Beach, CABuilt 2013 · S/N 4278N415QSRegistered aircraftBuilt 2005 · S/N 4014N421QSRegistered aircraftBuilt 2008 · S/N 4114N424PXNf Air Ventures LLC · Southfield, MIBuilt 2007 · S/N 4101N435QSDodson International Parts Inc · Rantoul, KSBuilt 2006 · S/N 4068N43ADAngstrom Aviation LLC · Southfield, MIS/N 4202N43XTAero Leasing II LLC · Apex, NCBuilt 2004 · S/N 4009N445QSDodson International Parts Inc · Rantoul, KSBuilt 2006 · S/N 4037N447JFN447jf LLC · New Hudson, MIBuilt 2010 · S/N 4187N448QSNji Sales Inc · Oklahoma City, OKBuilt 2007 · S/N 4100N450ABBlue Vista LLC · Newport Beach, CABuilt 2006 · S/N 4043N450ARN450ar LLC · Henderson, NVBuilt 2005 · S/N 4032N450BGT Champsions Houston LLC · Dallas, TXBuilt 2007 · S/N 4081N450BTTw Aviation LLC · Jupiter, FLBuilt 2006 · S/N 4065N450BWTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2016 · S/N 4357N450CEBlue Flag Two Ltd · Miamisburg, OHBuilt 2012 · S/N 4250N450DTAll Island Charter LLC · Woodbury, NYBuilt 2003 · S/N 4004N450FKAircraft T&F LLC Trustee · Wilmington, DEBuilt 2005 · S/N 4031N450FXService Electric Co · Cleveland, OHBuilt 2015 · S/N 4330N450GAGulfstream Leasing LLC · Savannah, GABuilt 2007 · S/N 4098N450GGTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2007 · S/N 4082N450JCSunshine State Capital Management LLC · Naples, FLBuilt 2012 · S/N 4255N450JSDjb Aviation LLC · Hackensack, NJBuilt 2015 · S/N 4344N450LMillard Management Company LLC · Omaha, NEBuilt 2010 · S/N 4213
Back to AD 2012-25-07