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.

N8948CKrupnik Amnon · Bethesda, MDBuilt 1976 · S/N 28-7690172N894ACAri Ben Aviator Inc · Fort Pierce, FLBuilt 2020 · S/N 2881413N894MAHot Wings Aviation LLC · Indianapolis, INBuilt 2023 · S/N 28020134N8967TKellys Flying Service LLC · Warrensburg, MOBuilt 1981 · S/N 28-8190209N8969CStrahl Guenter H · Jackson, NJBuilt 1976 · S/N 28-7690173N896ACAri Ben Aviator Inc · Fort Pierce, FLBuilt 2020 · S/N 2881414N896DFVenture North Aviation LLC · Cloquet, MNBuilt 2024 · S/N 2881696N8972CBosn Richard O · Scottsbluff, NEBuilt 1976 · S/N 28-7690174N897GArcher Flight LLC · Wilmington, DEBuilt 2018 · S/N 2881072N897HParagon Flight Training Co · Fort Myers, FLBuilt 2025 · S/N 28020244N897JWAmh Properties LLC · Auburn, ALFirst renewal noticeBuilt 2011 · S/N 2843698N897SCPeregrine Howard Partners II Lp · New Orleans, LABuilt 2024 · S/N 2881801N898DANopat LLC · North Charleston, SCBuilt 2000 · S/N 2843377N898GAtp Aircraft 9 LLC · Wilmington, DEBuilt 2021 · S/N 2881470N8996EHooligan Air LLC · Ponce Inlet, FLBuilt 1976 · S/N 28-7690217N8998EGeorgetson Michael J · Sayre, PABuilt 1976 · S/N 28-7690219N89BYLickteig David Leo Trustee · Ellensburg, WABuilt 1988 · S/N 2890102N8FNValiair Ltd Co Trustee · Casper, WYBuilt 1978 · S/N 28R-7837272N9003FStack Steven E · Santa Clarita, CABuilt 1976 · S/N 28-7790273N901AArcher Aero LLC · Wilmington, DEBuilt 2015 · S/N 2843801N901FCSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2002 · S/N 2842171N901PASkywest Leasing Inc · St George, UTS/N 2843481N902FCSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2003 · S/N 2842174N902PADefranco Peter Jr · Hueytown, ALBuilt 2002 · S/N 2843530N9036KGriffiths Gregory S · Johnson City, NYBuilt 1977 · S/N 28-7816184N9038KNorthwest Aviation LLC · Gig Harbor, WABuilt 1977 · S/N 28-7816185N903EESkywest Leasing Inc · St George, UTBuilt 1999 · S/N 2843229N903FCSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2003 · S/N 2842175N9040KGidden Aviation LLC · Katy, TXBuilt 1977 · S/N 28-7816186N9044FFiggins Matthew J · Stewardson, ILBuilt 1976 · S/N 28-7790277N9045KHounslow Michael L · Rockville, MDBuilt 1977 · S/N 28-7890173N904AGPeregrine Howard Aeroflight Owner LLC · New Orleans, LABuilt 2025 · S/N 2881944N905AGPeregrine Howard Aeroflight Owner LLC · New Orleans, LABuilt 2025 · S/N 2881945N9062KMiloud Chadd K · Fort Worth, TXBuilt 1977 · S/N 28-7816187N906GAtp Aircraft 9 LLC · Wilmington, DEBuilt 2021 · S/N 2881471N9077KPacific Coast Aero Inc · Torrance, CABuilt 1977 · S/N 28-7816188N90829Leading Edge Aviation Consultants LLC · Windsor, CTBuilt 1985 · S/N 28-8690011N9082UVolar Corp · El Cajon, CAS/N 28-8616051N9083BNorth Coast Flight School Inc · Meadville, PABuilt 1985 · S/N 28-8590076N9083DSachs Randy S · S Huntington, NYBuilt 1986 · S/N 28-8690050N9083KShuey Robert D III · Albertville, ALBuilt 1977 · S/N 28-7890174N9084NRose John K · Guilford, CTS/N 2890164N9085KSale Reported · Grayling, MISale reportedBuilt 1977 · S/N 28-7890175N9086KMedia Stew LLC · Carson City, NVBuilt 1977 · S/N 28-7890176N90874Myers Brian R · South Bend, INBuilt 1985 · S/N 28-8690014N9087DBolden Family Farms · Little Rock, ARBuilt 1986 · S/N 2816001N9088DMetro Aircraft Co · Bloomington, MNBuilt 1986 · S/N 28-8616049N9088QGolf Foxtrot Yankee LLC · Kingston, NYBuilt 1986 · S/N 2890002N9089CCrew Sourcing Inc · Wilmington, DEBuilt 1985 · S/N 28-8690016N908AArcher Aero LLC · Wilmington, DEBuilt 2015 · S/N 2843802
Back to AD 2016-07-21