OpenAirDocs.org
AD 2018-04-13

Registered aircraft · 1,368

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-04-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-04-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.

N100AKRegistered aircraftBuilt 2016 · S/N 2100N100SAEssay Management Services LLC · Oklahoma City, OKBuilt 2024 · S/N 21019N10131013sh LLC · Novato, CABuilt 2008 · S/N 20229N101GSG&S Aviation LLC · Richland, MSBuilt 2019 · S/N 2190N101KKKohler Co · Kohler, WIBuilt 2026 · S/N 55020260N101XTXto Energy Inc · Houston, TXBuilt 2016 · S/N 2109N102CECenterpoint Energy Service Co LLC · Houston, TXBuilt 2020 · S/N 20849N102PGPape Group Inc · Eugene, ORBuilt 2022 · S/N 2248N106SPPartee Aviation LLC · Big Spring, TXBuilt 2017 · S/N 55010008N10EHReh Finance Co · Salt Lake City, UTBuilt 2019 · S/N 20810N10SERadair LLC · Memphis, TNBuilt 2023 · S/N 20973N10UNGlobal Air LLC · Nashville, TNBuilt 2018 · S/N 20748N1107MAsifd LLC · Dallas, TXBuilt 2005 · S/N 20039N110MWRegistered aircraftBuilt 2024 · S/N 21001N111CMMunday Aviation LLC · Highland, UTBuilt 2023 · S/N 55010132N111EDBnp Holdings LLC · Lakewood Ranch, FLBuilt 2005 · S/N 20058N111ELContinuum Aviation LLC · Oklahoma City, OKBuilt 2005 · S/N 20051N111KKKohler Co · Kohler, WIBuilt 2026 · S/N 55020261N115ADAmerican Promotional Events Inc · Florence, ALBuilt 2011 · S/N 20331N115LFAirlynner LLC · Jackson, WYBuilt 2008 · S/N 20226N115SEAdvanta Aviation 3500 LLC · La Jolla, CABuilt 2022 · S/N 20926N116HFAirbourne International Inc · Wilmington, DEBuilt 2004 · S/N 20011N116NCNdc Equipment Leasing LLC · Lake Forest, ILBuilt 2021 · S/N 2221N117NTSanford Health · Sioux Falls, SDBuilt 2015 · S/N 55000034N117SFWildstar Partners LLC · Pittsford, NYBuilt 2022 · S/N 2249N118DBCitation X Parts LLC · Liberty, NCBuilt 2006 · S/N 20071N119DTTennthom Aviation Corp · La Vergne, TNBuilt 2024 · S/N 20988N120DRClo Equipment II LLC · Chicago, ILBuilt 2020 · S/N 20846N120JBRegistered aircraftBuilt 2026 · S/N 21121N120JCSouthwestern Jet Inc · Saint Louis, MOBuilt 2005 · S/N 20069N1212TTwelve Aviation LLC · Las Vegas, NVBuilt 2018 · S/N 55010051N1221JTurner Jim L · Dallas, TXBuilt 2012 · S/N 20364N1224MWilliams International Air Inc · Lancaster, NYBuilt 2013 · S/N 2031N123JKLayven Air II LLC · Battlefield, MOBuilt 2007 · S/N 20142N123QWilmington Trust Co Trustee · Wilmington, DEBuilt 2016 · S/N 20616N1242ZWilmington Trust Company Trustee · Wilmington, DEBuilt 2025 · S/N 55020242N125TRRaymond Corp · Greene, NYBuilt 2025 · S/N 2302N126PHPam Aviation LLC · Enola, PABuilt 2013 · S/N 20435N127EBForty Acres Aviation LLC · Wheeling, ILBuilt 2014 · S/N 20515N127SFConstellation Leasing LLC · Rochester, NYBuilt 2020 · S/N 2204N12ECEntergy Services LLC · New Orleans, LABuilt 2017 · S/N 20717N12FRegistered aircraftBuilt 2026 · S/N 21114N1313ACasbj Air LLC · Miami, FLBuilt 2013 · S/N 20403N131FBRegistered aircraftBuilt 2021 · S/N 55020131N131JRC&S Wholesale Grocers LLC · Keene, NHBuilt 2024 · S/N 21046N131KRStr Holdings LLC · Memphis, TNBuilt 2020 · S/N 20855N131KSRegistered aircraftBuilt 2006 · S/N 20092N135CGCti Of North Carolina Inc · Wilmington, NCBuilt 2023 · S/N 20955N136DBCitation X Parts LLC · Liberty, NCBuilt 2008 · S/N 20222N137SFConstellation Leasing LLC · Rochester, NYBuilt 2019 · S/N 2178
Back to AD 2018-04-13