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.

N82720Skydove Ministries LLC · Glenmoore, PABuilt 1980 · S/N 28-8190046N8272CHaeuser August A · Stowe, PABuilt 1980 · S/N 28-8116048N8272FMidwest National Flying Club Inc · Gladstone, MOS/N 28-7790236N8272VSkybound Aviation LLC · Greensboro, NCBuilt 1980 · S/N 28-8116050N8273AElon Aviation LLC · Burlington, NCBuilt 1980 · S/N 28-8190047N8273VArctic Fox Aircraft LLC · Queen Creek, AZBuilt 1980 · S/N 28-8190050N82743Up And Away Aviation LLC · Poughkeepsie, NYS/N 28-8116051N82746St Pete Aviation Services LLC · Saint Petersburg, FLBuilt 1980 · S/N 28-8190054N8274HThunderbird Aircraft Co · Bloomington, MNBuilt 1980 · S/N 28-8190052N82750Jabour Virginia · Port Orange, FLBuilt 1980 · S/N 28-8116053N82757Registration Pending · Fairmont, WVRegistration pendingBuilt 1980 · S/N 28-8116054N8275DMoore Aviation Inc · Beaver Falls, PABuilt 1997 · S/N 2843096N82765Musumeci Paul N · Wilmington, DEBuilt 1980 · S/N 28-8190062N8276HDelalat Sean · San Diego, CABuilt 1980 · S/N 28-8116055N8276NShreffler Christine A · Ballwin, MOBuilt 1980 · S/N 28-8116056N8276VNorthrop John B · Madison, WIBuilt 1980 · S/N 28-8190056N8276XBnb LLC · Greenwich, CTBuilt 1980 · S/N 28-8190057N8276ZPar Five Enterprises LLC · Columbus, OHBuilt 1980 · S/N 28-8190061N82779Northeast Planes Aviation Inc · Laramie, WYBuilt 1980 · S/N 28-8190058N82783Gulf Atlantic Airways Inc · Gainesville, FLBuilt 1980 · S/N 28-8116057N827NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2020 · S/N 2881289N8282VEnsemble Air LLC · Laramie, WYBuilt 1980 · S/N 28-8116060N82832Stokke Todd · Magnolia, TXBuilt 1980 · S/N 28-8190066N82836Aerodreams Aviation LLC · Raleigh, NCBuilt 1980 · S/N 28-8190071N8283VMiloud Chadd K · Fort Worth, TXBuilt 1980 · S/N 28-8116065N8283YPhillips Thaddus L · Knoxville, TNBuilt 1980 · S/N 28-8190064N8285BHyldburg Aviation Inc · Plymouth, MABuilt 1980 · S/N 28-8116066N8285YAmerican Aviation Inc · Woods Cross, UTFirst renewal noticeBuilt 1980 · S/N 28-8190073N82864Meyer Fredric Kim · Orange, CABuilt 1982 · S/N 28-8316005N8286CMidwest Sky Chasers Nfp · Algonquin, ILBuilt 1975 · S/N 28-7690110N8288AJohnson Carmen · White Cloud, MIBuilt 1982 · S/N 28-8390020N8288FAtwood Jason P · La Porte, INBuilt 1976 · S/N 28-7790237N8288ZPabon Hugo · Granada Hills, CABuilt 1980 · S/N 28-8116071N8289AAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1980 · S/N 28-8116072N8289XSheitelman Mitchell · Warren, NJBuilt 1980 · S/N 28-8190080N82921New Hampshire Flying Association Inc · Nashua, NHBuilt 1982 · S/N 28-8390007N8292DHuffman Jacob M III · Burleson, TXBuilt 1982 · S/N 28-8316009N8294LAts Tennessee Inc · Oneida, TNBuilt 1982 · S/N 28-8316011N82953Sky Fox Aircraft LLC · Queen Creek, AZBuilt 1980 · S/N 28-8190088N8295HAnywhere Atp LLC · Mt Juliet, TNBuilt 1982 · S/N 28-8316013N8295TFlight Services Inc · Headland, ALBuilt 1980 · S/N 28-8116082N8295ZWhitaker Stephen P · Northville, MIBuilt 1980 · S/N 28-8190087N829JSRedstone Arsenal Flying Activity · Huntsville, ALBuilt 2001 · S/N 2842123N82BZTeuber Gary J · Sister Bay, WIBuilt 1982 · S/N 28-8390017N83009Paris Air Inc · Vero Beach, FLS/N 28-8116088N83013Tjmc LLC · Riverbank, CABuilt 1980 · S/N 28-8116090N83016Maks97 LLC · Sparta, MIBuilt 1980 · S/N 28-8116091N83021Kosbruk Boris R Jr · Perryville, AKBuilt 1980 · S/N 28-8190104N8302A4 Moons Aviation Inc · Danvers, MABuilt 1980 · S/N 28-8116092N8302TYarb LLC · Cleburne, TXBuilt 1980 · S/N 28-8190103
Back to AD 2016-07-21