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

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

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.

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

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N100GZN100gz Inc Trustee · Cheyenne, WYBuilt 2021 · S/N 680A0291 N100PETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2018 · S/N 680-0580 N100TPTes Aviation LLC · Southbury, CTBuilt 2012 · S/N 510-0418 N1010NScoular Co · Omaha, NEBuilt 2012 · S/N 680-0331 N101EFEngineered Floors LLC · Dalton, GABuilt 2014 · S/N 680-0532 N101FCL&B Air LLC · Northbrook, ILBuilt 2007 · S/N 680-0136 N101FUAerospace Trust Management LLC Trustee · Wilmington, DEBuilt 2009 · S/N 510-0207 N101PGPape Group Inc · Eugene, ORBuilt 2012 · S/N 680-0336 N1027PTextron Aviation Inc · Wichita, KSBuilt 2004 · S/N 680-0004 N102DSMaria Squared Aviation LLC · Saint Louis, MOBuilt 2008 · S/N 510-0095 N105CDBjr Management LLC · Goldsboro, NCBuilt 2014 · S/N 680-0523 N105JBravo Aviation LLC · Belmond, IABuilt 2009 · S/N 510-0277 N107DAAviation South LLC · South Lyon, MIBuilt 2006 · S/N 680-0063 N108BMPoet Inc · Sioux Falls, SDBuilt 2018 · S/N 680A0108 N110LEPlatinum Air LLC · Fort Worth, TXBuilt 2005 · S/N 680-0022 N111JMLantzman Holdings LLC · San Diego, CABuilt 2011 · S/N 510-0383 N116MCJoc Aviation LLC · Nashville, TNBuilt 2009 · S/N 510-0266 N118TRCommodore Aviation LLC · Greensboro, NCBuilt 2025 · S/N 680A0452 N11GUSeamint LLC · Newton Grove, NCBuilt 2007 · S/N 680-0147 N11UDAir Shamrock LLC · Fort Wayne, INS/N 680-0303 N120FTAtlas Chartering Services Inc · Laguna Hills, CABuilt 2010 · S/N 510-0322 N1219MMeijer Distribution Inc · Grand Rapids, MIBuilt 2019 · S/N 680A0192 N121JSJ R Simplot Company LLC · Boise, IDBuilt 2018 · S/N 680-0581 N122PHPamplemousse Corp · Wilmington, DEBuilt 2010 · S/N 680-0294 N128AJAvish Air LLC · Louisville, KYBuilt 2008 · S/N 6800218 N12RMAviana Mustang LLC · Edmond, OKBuilt 2009 · S/N 510-0226 N12VURegistered aircraftBuilt 2014 · S/N 680-0531 N1326AMscci Capital Holdings LLC · Naples, FLBuilt 2015 · S/N 680A0017 N133TFColumbia Wv Aviation LLC · Wilmington, DEBuilt 2009 · S/N 510-0191 N1411MWasioja LLC · Dodge Center, MNBuilt 2024 · S/N 680A0406 N146ARJet Stream LLC · San Carlos, CABuilt 2012 · S/N 510-0413 N146GGfo Aviation LLC · Schofield, WIBuilt 2022 · S/N 680A0294 N147WRCore G Air LLC · Osteen, FLBuilt 2005 · S/N 680-0059 N149JSJr Simplot Co LLC · Boise, IDBuilt 2026 · S/N 680A0482 N150TGHome Run LLC · Oakland, CABuilt 2007 · S/N 680-0127 N151YDYellow Dart LLC · Warroad, MNBuilt 2008 · S/N 680-0197 N153SGDfm III LLC · Cortland, NYBuilt 2006 · S/N 680-0101 N155MMLakeshore Pets LLC · Cleveland, NCBuilt 2014 · S/N 510-0452 N156SWWhitney Group LLC · Larose, LABuilt 2010 · S/N 680-0296 N15DPWalmart Inc · Bentonville, ARBuilt 2017 · S/N 680-0577 N15LVPronto LLC · Oklahoma City, OKBuilt 2015 · S/N 680-0551 N15YSYellow Steel LLC · Mobile, ALBuilt 2025 · S/N 680A0453 N161CBTextron Aviation Inc · Wichita, KSS/N 680A0491 N1630Cox Aviation LLC · Atlanta, GABuilt 2025 · S/N 680A0449 N163RSummit Air LLC · Miami, FLBuilt 2007 · S/N 680-0163 N163TCDodson International Parts Inc · Rantoul, KSBuilt 2007 · S/N 510-0039 N165RCCbp Air Logistics LLC · Statham, GABuilt 2009 · S/N 680-0281 N166HLPark Associates Inc · East Aurora, NYBuilt 2005 · S/N 680-0035 N167SARegistration Pending · North Salt Lake, UTRegistration pendingBuilt 2005 · S/N 680-0043 N168LTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2018 · S/N 680A0168

Back to AD 2018-07-13