OpenAirDocs.org
AD 2018-07-13

Registered aircraft · 967

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

N7QFQuail Aviation LLC · Holdrege, NEBuilt 2015 · S/N 510-0456N800FNMeander Air II LLC · Moon Twp, PABuilt 2015 · S/N 680A0006N800RBRmb Aviation LLC · Bossier City, LABuilt 2005 · S/N 680-0030N807LPTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2021 · S/N 680-0326N808LRRocket 21 Aviation LLC · Sherwood, ARBuilt 2022 · S/N 680A0327N80FWMedical Facilities Of America Inc · Roanoke, VAFirst renewal noticeBuilt 2008 · S/N 680-0238N810BLLund Investments LLC · Newport Beach, CABuilt 2009 · S/N 510-0188N811MBJetquest LLC · Greenville, SCBuilt 2007 · S/N 680-0156N812JBuckeye Aviation LLC · Henderson, NVBuilt 2013 · S/N 510-0435N814WSVenturi Aviation LLC · Lolo, MTBuilt 2007 · S/N 510-0032N817TVSovereign I LLC · Fishers, INBuilt 2008 · S/N 680-0213N818MFN818mf LLC · Austin, TXBuilt 2004 · S/N 680-0007N81CBMustang Aero Inc Trustee · Wilmington, DEBuilt 2013 · S/N 510-0439N81NTHd Air LLC · Mercer, PAS/N 680-0305N81WLTsds Leasing LLC · Wellington, FLBuilt 2009 · S/N 510-0165N820CAConagra Brands Inc · Omaha, NEBuilt 2018 · S/N 680A0134N820UTGarmin International Inc · Olathe, KSBuilt 2011 · S/N 510-0332N823MRaptor Aviation LLC · Edmond, OKS/N 510-0228N824CAVildosola Aviation LLC · San Diego, CABuilt 2018 · S/N 680A-0136N824HHHilltop Holdings Inc · Dallas, TXBuilt 2011 · S/N 680-0310N827NMWhite Knuckle Endeavors LLC · Tustin, CABuilt 2010 · S/N 510-0294N827SMFh Aviation LLC · Collierville, TNBuilt 2011 · S/N 680-0316N82TXFitr LLC · Plano, TXBuilt 2021 · S/N 680A0290N830GGSmita 1212 LLC · Trumbull, CTBuilt 2008 · S/N 680-0200N831MFClass Act Aviation LLC · Marshfield, MOBuilt 2008 · S/N 510-0118N834CAConagra Brands Inc · Omaha, NEBuilt 2025 · S/N 680A0460N838LJMcckc LLC · Bellevue, WABuilt 2006 · S/N 680-0074N83FGIfaj LLC · Palm Harbor, FLBuilt 2011 · S/N 510-0376N83PMRh Best LLC · Huntsville, TXBuilt 2018 · S/N 680A0175N8481HN8481h LLC · Wilmington, DEBuilt 2026 · S/N 680A0463N849BCMhg Aviation LLC · Boca Raton, FLBuilt 2011 · S/N 510-0365N858MGMgi Air Inc · Dubuque, IABuilt 2014 · S/N 680A0002N859JCShamrock 5 LLC · Lexington, KYBuilt 2017 · S/N 680A0077N85LHLh300 LLC · New Castle, DEBuilt 2010 · S/N 510-0338N85VCElevon Aviation LLC · Menlo Park, CABuilt 2007 · S/N 510-0023N862GSBuzzard Aviation LLC · St Simons Is, GABuilt 2012 · S/N 510-0406N863CAConagra Brands Inc · Omaha, NEBuilt 2018 · S/N 680A0166N865CAConagra Brands Inc · Omaha, NEBuilt 2018 · S/N 680A0167N865ECWrc Turtle Creek · Dallas, TXBuilt 2005 · S/N 680-0028N868WG674 Partners LLC · Erie, PABuilt 2017 · S/N 680A0076N86WHRegistered aircraftBuilt 2012 · S/N 510-0416N874PWBlue Sky Mountain LLC · Dana Point, CABuilt 2011 · S/N 510-0392N878PRJmair LLC · Chippewa Falls, WIBuilt 2011 · S/N 510-0362N878TMBt Aviation LLC · Springfield, MOBuilt 2016 · S/N 680A0049N87EKEcj Bravo 2004 LLC · Wilmington, DEBuilt 2005 · S/N 680-0053N87WCA500 LLC · Bridgehampton, NYBuilt 2011 · S/N 510-0385N881EUBank Of Utah Trustee · Salt Lake City, UTBuilt 2008 · S/N 680-0223N883JABei Aviation LLC · Alpharetta, GABuilt 2014 · S/N 680-0517N884HJBank Of Utah Trustee · Salt Lake City, UTBuilt 2005 · S/N 680-0040N884K510 Mustang Corp · Casper, WYBuilt 2017 · S/N 510-0476
Back to AD 2018-07-13