AD 2018-07-16

Registered aircraft · 282

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-16')
    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-16')
  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.

N246CFArq Aviation LLC · Wilmington, NCBuilt 2014 · S/N 42.N151N251JMStoney Creek Aviation LLC · Houston, TXBuilt 2022 · S/N 62.220N251SAA Tail Of Two Cities LLC · Elkhart, INBuilt 2024 · S/N 62.C077N257LAAa Aviation LLC · Nashville, TNBuilt 2023 · S/N 42.N507N25HSSkyline Aviation Inc · San Angelo, TXBuilt 2013 · S/N 42.N114N262GFTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2022 · S/N 62.207N264LAOntario Holdings LLC · Sheridan, WYBuilt 2023 · S/N 62.C054N265LAJk Aviation LLC · Knoxville, TNBuilt 2024 · S/N 62.C092N265PSMyflight Five LLC · Lake Mary, FLBuilt 2025 · S/N 42.N605N267PSBerlet Consulting LLC · Odessa, FLBuilt 2024 · S/N 62.C087N269LASanstone Management Company LLC · Arden, NCBuilt 2024 · S/N 62.C079N271CFWind Rising Ventures LLC · Columbus, MSBuilt 2023 · S/N 62.C057N272DD2dd Aviation LLC · Lafayette, CABuilt 2023 · S/N 62.C053N272MBYankee Lima One LLC · Bolingbrook, ILBuilt 2008 · S/N 42.AC117N276LANext Stop Mars LLC · Hartwell, GABuilt 2024 · S/N 62.C076N27SJ0x1b LLC · Brooklyn, NYBuilt 2006 · S/N 42.AC014N296LANterjet LLC · Sheridan, WYBuilt 2019 · S/N 62.C020N296SKAlf Ix LLC · Chicago, ILBuilt 2025 · S/N 42.N609N2DKClausen Frederik M · Chicago, ILBuilt 2024 · S/N 62.276N301RHQualitair LLC Trustee · MichelstadtBuilt 2024 · S/N 62.283N302EREmbry Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2023 · S/N 42.N527N303SWSkywarrior Flight Training LLC · Pensacola, FLBuilt 2016 · S/N 42.N202N304SWSkywarrior Flight Training LLC · Pensacola, FLBuilt 2016 · S/N 42.N203N305EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2016 · S/N 42.N205N306EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2016 · S/N 42.N206N308EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2016 · S/N 42.N210N309EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2016 · S/N 42.N211N310XAJetnexa Ten LLC · Gilbert, AZBuilt 2024 · S/N 62.C072N311EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2016 · S/N 42.N212N311LHWingsleasing LLC · Wichita, KSBuilt 2005 · S/N 42.036N312EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2016 · S/N 42.N213N313EREmbry Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2024 · S/N 42.N535N314EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2024 · S/N 42.N536N3150AOklahoma Aviation LLC · Bethany, OKS/N 42.N223N315XAJetnexa Thirteen LLC · Gilbert, AZBuilt 2025 · S/N 42.N590N316JZZockoll Janice M · Hudson, OHBuilt 2023 · S/N 62.C062N318EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2024 · S/N 42.N539N319EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2024 · S/N 42.N547N320AVWestwind School Of Aeronautics Phoenix LLC DBA · Goodyear, AZBuilt 2023 · S/N 42.N502N320EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2024 · S/N 42.N548N322EREmbry Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2024 · S/N 42.N549N323EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2024 · S/N 42.N550N324EREmbry Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2024 · S/N 42.N552N327EREmbry Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2024 · S/N 42.N553N328EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2024 · S/N 42.N556N329EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2024 · S/N 42.N537N32GH1 Diamond 62 LLC · Santa Fe, NMBuilt 2016 · S/N 62.026N331JSStaniforth James A · Tehachapi, CABuilt 2011 · S/N 31038N3364ZBellfask LLC · Paris, TXBuilt 2022 · S/N 62.C051N33KFKermitflies LLC · Bend, ORBuilt 2016 · S/N 62.023
Back to AD 2018-07-16