OpenAirDocs.org
AD 2016-11-13

Registered aircraft · 38

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-11-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:2016-11-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.

N101ASWilliams Roy S · Kendallville, INS/N 027063N112SAHeartland Aviation Inc · Alliance, NEBuilt 1977 · S/N 026954N14420Shugg Gregory G · Flagler Beach, FLBuilt 1981 · S/N 175114N161ASKeegans John T · Defuniak Springs, FLBuilt 1977 · S/N 026940N1973CRed Wing Soaring Association · Osceola, WIBuilt 1973 · S/N 025725N2414JGunnarsson Jon · Concrete, WAS/N 025313N2426VSpokane Soaring Societ Inc · Spokane, WAS/N 026502N254BAPullup Associates Inc · East Wenatchee, WABuilt 1974 · S/N 026030N3280SArnold Sarah D · Benton, TNBuilt 1973 · S/N 025429N4659Hutchings Mathew J · Camano Island, WABuilt 1971 · S/N 174715N46RDLake Norman Flyers LLC · Huntersville, NCS/N 174129N46RMSpreuer Dennis W · Howe, INS/N 026933N48034Kornfield Edward A · Anchorage, AKBuilt 1975 · S/N 026130N48039Barron Aviation LLC · Perry, MOS/N 026102N48052Nord Terence Lee · Pembina, NDBuilt 1975 · S/N 026103N48070Piercy Ronald S · Moses Lake, WABuilt 1974 · S/N 026036N52ASCascade Soaring Society · East Wenatchee, WABuilt 1977 · S/N 027056N6288White Sands Soaring Association Inc · Alamogordo, NMBuilt 1973 · S/N 025520N65141Senner David R · Springfield, ORS/N 026408N688JAWestern Antique Aeroplane & Automobile Museum · Hood River, ORS/N 025414N69ASAll Attitude Aviation Inc · Edgewater, FLS/N 026941N70732Central Alabama Soaring Association · Vestavia, ALBuilt 1977 · S/N 026935N70741Big Sky Jet Inc · Bozeman, MTS/N 027341N77ASHigh Flights Soaring Club · Peyton, COBuilt 1978 · S/N 027006N805SBKc Eagles Soaring Club · Gardner, KSBuilt 1976 · S/N 026805N83ASSamadi Jamshid · Leesburg, VAS/N 026652N86660Tulsa Skyhawks Inc · Tulsa, OKBuilt 1972 · S/N 025422N88ASSchutze Richard P Trustee · Ojai, CAS/N 026723N88JMReller Bernard D · Gainesville, FLS/N 026820N90846Minden Soaring Club Inc · Minden, NVBuilt 1973 · S/N 025702N90860Stearman Aviation Inc · Crawford, COBuilt 1973 · S/N 025716N97ASHinckley David D · Belton, TXBuilt 1978 · S/N 027019N98KKWhitcomb Matthew J · Roanoke, VABuilt 1925 · S/N 027155N99950Omaha Soaring Club Inc · Omaha, NEBuilt 1974 · S/N 025823N99951Big Sky Jet Inc · Bozeman, MTS/N 025824N99952Ps Soaring Inc · Bellefonte, PAS/N 025903N99968Ps Soaring Inc · Bellefonte, PAS/N 026048N9NVPietsch Warren A · Minot, NDBuilt 1972 · S/N 175220
Back to AD 2016-11-13