AD 2018-21-13

Registered aircraft · 240

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

N792JCAir Jordan LLC · Natchez, MSBuilt 2026 · S/N 42000288N798NHPropertyco LLC · Eugene, ORBuilt 2025 · S/N 42000280N800RDPinnacle Aviation LLC · New York, NYBuilt 2017 · S/N 42000081N809CNAllen Air LLC · Creola, ALBuilt 2018 · S/N 42000116N809GGTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2026 · S/N 42000284N815JJMsh Leasing LLC · Thomasville, GABuilt 2017 · S/N 42000083N815RMRomalou LLC · Fort Lauderdale, FLBuilt 2019 · S/N 42000164N816JDMci Rentals Lc · North Bay Village, FLBuilt 2019 · S/N 42000176N818ATwin Flyers LLC · Alpharetta, GABuilt 2024 · S/N 42000275N820JLLaminar Holdings LLC · Katy, TXBuilt 2019 · S/N 42000140N824GBTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2019 · S/N 42000174N826EAndy Leavitt Enterprises LLC · North Bend, ORBuilt 2019 · S/N 42000170N827HJHonda Aviation Service Co Inc · Greensboro, NCS/N 42000298N829DLFrayer Jets 4 LLC · Oklahoma City, OKBuilt 2017 · S/N 42000063N829LRHonda Aviation Service Co Inc · Greensboro, NCS/N 42000301N82DGPilotdaria LLC · Big Pine Key, FLBuilt 2015 · S/N 42000012N82HMH & M Bay Inc · Federalsburg, MDBuilt 2019 · S/N 42000154N82PWendell Shawn · Houston, TXBuilt 2018 · S/N 42000134N83NCFairway Capital Partners Inc · Greensboro, NCBuilt 2024 · S/N 42000271N843JTMuncie Aviation Co · Muncie, INBuilt 2021 · S/N 42000222N856WD16th Fairway Air LLC · Tulsa, OKBuilt 2016 · S/N 42000037N85NUGsp 75 LLC · Grand Haven, MIBuilt 2018 · S/N 42000135N862DWJackson Executive Transport LLC · Jackson, MIBuilt 2025 · S/N 42000283N875JPBoyd Aviation Pv LLC · Saint Augustine, FLBuilt 2023 · S/N 42000255N878HJLuxsol LLC · Laredo, TXBuilt 2017 · S/N 42000059N87HJAviation Industries LLC · Aurora, ILBuilt 2017 · S/N 42000087N894LLJlp Group LLC · Baton Rouge, LABuilt 2020 · S/N 42000204N903THLight Moon LLC · Newton, ALBuilt 2021 · S/N 42000224N909BPGsh Travel LLC · Oklahoma City, OKBuilt 2018 · S/N 42000099N90CWSpring Leasing LLC · Mobile, ALBuilt 2018 · S/N 42000125N913JTS&S Contractors LLC · Leitchfield, KYBuilt 2020 · S/N 42000202N918AJetko LLC · Boston, MABuilt 2023 · S/N 42000248N949LLRcn Aviation LLC · Missoula, MTBuilt 2018 · S/N 42000100N94EFKipo LLC · Harahan, LABuilt 2023 · S/N 42000252N959AHAmerican Honda Motor Co Inc · Greensboro, NCBuilt 2020 · S/N 42000198N95NUCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 2020 · S/N 42000200N97ZTHonda Aviation Service Co Inc · Greensboro, NCS/N 42000306N992WSRe Wdc Inc · Maitland, FLBuilt 2017 · S/N 42000073N999JBSilverleaf V LLC · Scottsdale, AZS/N 42000219N999LLSky Access LLC · San Juan, PRBuilt 2025 · S/N 42000278
Back to AD 2018-21-13