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.

N510PKCj3 Air LLC · Kingman, AZBuilt 2010 · S/N 510-0304N510PXSooner Turbine Aviation LLC · Oklahoma City, OKBuilt 2011 · S/N 510-0359N510RMCitation Partners LLC · Raleigh, NCBuilt 2008 · S/N 510-0103N510SAConstruction Components Truss Division Ll · Toccoa, GABuilt 2008 · S/N 510-0094N510SWJw Boca One LLC · Boca Raton, FLBuilt 2010 · S/N 510-0290N510TGTfs Aviation Corp · Fort Lauderdale, FLS/N 510-0122N510TWJd Enterprises LLC · Tenants Harbor, MEBuilt 2009 · S/N 510-0240N510WGSejnoha Air LLC · Sioux Falls, SDBuilt 2010 · S/N 510-0317N510WPVcp Holdings 2 LLC · Wooster, OHBuilt 2008 · S/N 510-0138N511JFPhoenix Construction Services Inc · Lynn Haven, FLBuilt 2006 · S/N 680-0104N511MDNew Southern Cross Aviation LLC · River Forest, ILBuilt 2009 · S/N 510-0279N511QSRegistered aircraftBuilt 2018 · S/N 680A0148N512QSRegistered aircraftBuilt 2016 · S/N 680A0045N513QSRegistered aircraftBuilt 2016 · S/N 680A0046N514QSRegistered aircraftBuilt 2016 · S/N 680A0052N515QSRegistered aircraftBuilt 2016 · S/N 680A0053N516CMTexas Air Machines LLC · Corpus Christi, TXBuilt 2015 · S/N 680-0549N516DBAshy M LLC · San Antonio, TXBuilt 2005 · S/N 680-0038N516PMV Aviation LLC · Overland Park, KSBuilt 2014 · S/N 6800529N516QSRegistered aircraftBuilt 2018 · S/N 680A0149N516STStrategic Aviation LLC · Flowood, MSBuilt 2017 · S/N 680A0071N518ARTextron Aviation Inc · Wichita, KSBuilt 2026 · S/N 680A0489N518KBLatitude 680a-0067 LLC · Wilmington, DEBuilt 2016 · S/N 680A0067N518QSRegistered aircraftBuilt 2022 · S/N 680A0298N519LMMeijer Distribution Inc · Grand Rapids, MIBuilt 2016 · S/N 680A0055N519QSRegistered aircraftBuilt 2016 · S/N 680A0054N51HBKilo Echo Management LLC · Kansas City, MOBuilt 2008 · S/N 510-0108N51NYFlacol LLC · Newark, DEBuilt 2010 · S/N 510-0286N51TETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2017 · S/N 680-0572N520JMLamplighter 88 LLC · San Antonio, TXBuilt 2009 · S/N 510-0179N520QSRegistered aircraftBuilt 2016 · S/N 680A0056N521BUBridge Funding Group Inc · Hunt Valley, MDBuilt 2012 · S/N 680-0330N521QSRegistered aircraftBuilt 2016 · S/N 680A0058N522JARx2 Partners LLC · Chester, VABuilt 2005 · S/N 680-0025N522QSRegistered aircraftBuilt 2016 · S/N 680A0060N523QSRegistered aircraftBuilt 2016 · S/N 680A0061N524QSRegistered aircraftBuilt 2016 · S/N 680A0062N525QSRegistered aircraftBuilt 2016 · S/N 680A0063N526QSRegistered aircraftBuilt 2017 · S/N 680A0068N527QSRegistered aircraftBuilt 2017 · S/N 680A0069N528QSRegistered aircraftBuilt 2022 · S/N 680A0329N529QSRegistered aircraftBuilt 2022 · S/N 680A0309N530AJBeam 33 Inc · Billings, MTS/N 510-0234N530KABank Of Utah Trustee · Salt Lake City, UTBuilt 2020 · S/N 680-0595N530QSRegistered aircraftBuilt 2017 · S/N 680A0072N530RMR2mh Jet Air LLC · Bend, ORS/N 510-0474N531FCN50sq LLC · Lubbock, TXBuilt 2006 · S/N 680-0107N531PHBank Of Utah Trustee · Salt Lake City, UTBuilt 2023 · S/N 680A0345N531QSRegistered aircraftBuilt 2022 · S/N 680A0311N532BCTextron Aviation Inc · Wichita, KSS/N 680A0503
Back to AD 2018-07-13