OpenAirDocs.org
AD 2016-07-21

Registered aircraft · 5,443

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:2016-07-21')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2016-07-21')
  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.

N908AGPeregrine Howard Aeroflight Owner LLC · New Orleans, LABuilt 2025 · S/N 2881946N908NDUniversity Of North Dakota · Grand Forks, NDBuilt 2020 · S/N 2881368N9090BHaynes Aviation LLC · Wetumpka, ALBuilt 1986 · S/N 2890003N9093FArcher 93f LLC · Danvers, MABuilt 1986 · S/N 28-8690039N9093KPdg Leasing LLC · Maryland Heights, MOBuilt 1985 · S/N 28-8690032N9093SEllis Derek J · Austin, MNBuilt 1985 · S/N 28-8690033N9093ZCloud Niner LLC · Furlong, PABuilt 1985 · S/N 28-8690037N9094KWomack-Kalla Dennis E · Philadelphia, PABuilt 1985 · S/N 28-8690034N9098GTravel Express Aviation LLC · West Chicago, ILBuilt 1985 · S/N 28-8616024N9098KD G Aircraft LLC · Lewes, DEBuilt 1985 · S/N 28-8616025N9099KWallace Jacob M · Central Point, ORBuilt 1977 · S/N 28R-7837028N909JLAims Community College · Greeley, COBuilt 2019 · S/N 2881184N909MAKenzy 2022 LLC · Castle Rock, COBuilt 2019 · S/N 2881186N9101THahn Derrick J · Combine, TXBuilt 1985 · S/N 28-8690019N9102KM & T Aircraft LLC · North Canton, OHBuilt 1977 · S/N 28R-7837029N9105XHedgehopper Flying Club Inc · Springfield, MOBuilt 1986 · S/N 2890006N9106YRegion Flyers LLC · Valparaiso, INBuilt 1985 · S/N 28-8616001N91071Warrior II LLC · Zionsville, INBuilt 1985 · S/N 28-8616004N91077Brown Patricia L · Destin, FLBuilt 1985 · S/N 28-8690023N91079Gholson Travis R · Carmi, ILBuilt 1985 · S/N 28-8690024N9107SMaul Errol T · Ocala, FLBuilt 1986 · S/N 2890010N9109QBurns Timothy M · Huntington, NYBuilt 1986 · S/N 2890011N910MREcho Dynamics · La Mesa, CABuilt 1979 · S/N 28-7990549N9110UPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28020280N9112ZWalters Darren · Overland Park, KSBuilt 1986 · S/N 2890017N9114DMacair Aviation LLC · Xenia, OHBuilt 1987 · S/N 2890032N9115QSoto Daniel-Rey · Smiths Station, ALBuilt 1987 · S/N 2890033N9118SSt Pete Aviation Services LLC · Saint Petersburg, FLBuilt 1986 · S/N 2816010N9118ZFlying Mermaid LLC · Aiea, HIBuilt 1986 · S/N 2890022N9127NKohler David W · Portland, INBuilt 1993 · S/N 2890175N912BLWingsleasing LLC · Wichita, KSBuilt 2025 · S/N 2881854N912JDaucher Kelsey K · Oak Harbor, WABuilt 1978 · S/N 28-7916064N912PABird Acquisition LLC · Phoenix, AZBuilt 1999 · S/N 2843302N9131KThompson Flying Club Inc · New Cumberland, PABuilt 1976 · S/N 28-7690220N9132KMcwhorter Mark Edward · Flower Mound, TXBuilt 1976 · S/N 28-7690221N91338Kejair LLC · San Francisco, CABuilt 1985 · S/N 28-8616008N9134YParis Air Inc · Vero Beach, FLBuilt 1985 · S/N 28-8616010N913TGThomas Home Center Inc · Sheridan, ORBuilt 1985 · S/N 28-8616011N9144TShiflett Philip B · Marietta, OHBuilt 1985 · S/N 28-8690029N914PACoco Aircraft Inc · Merritt Island, FLBuilt 1999 · S/N 2843303N9151NPlane Nonsense Inc · Middletown, DEBuilt 1988 · S/N 2890090N915GArcher Flight LLC · Wilmington, DEBuilt 2018 · S/N 2881073N915PABird Acquisition LLC · Phoenix, AZBuilt 1999 · S/N 2843304N915TTLake Elmo Aero LLC · Lake Elmo, MNBuilt 1977 · S/N 28-7890158N91630Skylink Xpress Inc · San Bernardino, CAS/N 2841055N91631Seale Taylor Edward · Madison, WIBuilt 1993 · S/N 2890177N91634Tharp Anthony W · Charleston, WVBuilt 1993 · S/N 2890178N9163ZTrident Aircraft Inc · Easton, MDBuilt 1989 · S/N 2841056N9165KCasey Matthey J · Sedalia, COBuilt 1989 · S/N 2890104N916PASkywest Leasing Inc · St George, UTBuilt 1999 · S/N 2843305
Back to AD 2016-07-21