OpenAirDocs.org
AD 2016-07-21

Registered aircraft · 5,462

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.

N2134ERice Larry Anthony Trustee · Yucaipa, CABuilt 1978 · S/N 28-7990180N2134JMcmahan Michael Anthony · Dunwoody, GABuilt 1978 · S/N 28-7990218N2135BMiloud Chadd K · Fort Worth, TXBuilt 1978 · S/N 28-7916110N2135FMark Alan Bennett · Trinidad, COS/N 28-7990188N2136JHanus John E · North Kingstown, RIBuilt 1978 · S/N 28-7990219N2136MWashington Israel · Cincinnati, OHBuilt 1977 · S/N 28-7816253N2136YW Tech Consulting Inc · Wilmington, DEBuilt 1979 · S/N 28-7916368N2137JAdverse Yaw LLC · Milford, CTBuilt 1978 · S/N 28-7916205N2139JHotung Lisa M · Amherst, NYBuilt 1978 · S/N 28-7990220N213BPJim Nichols Air Service LLC · Fincastle, VABuilt 1986 · S/N 28-8690056N2140VSidhu Harish · Anaheim, CABuilt 1979 · S/N 28-7990340N2140YNorcal Flight Club · Vacaville, CABuilt 1979 · S/N 28-7916372N21411Piper Partners · Coventry, CTBuilt 1978 · S/N 28-7990044N21412Long Island Aviators LLC · Seaford, NYBuilt 1978 · S/N 28-7990045N2141JRegistered aircraftBuilt 1978 · S/N 28-7990221N2141RM5:16 Ventures LLC · Brush Prairie, WABuilt 1979 · S/N 28-7990302N2143YBk Aviation Services LLC · Graford, TXBuilt 1979 · S/N 28-7916357N21441Paris Air Inc · Vero Beach, FLBuilt 1978 · S/N 28-7916040N21442Ducote Randal J · Parker, COBuilt 1978 · S/N 28-7990048N21443Compton James R · Boise, IDBuilt 1978 · S/N 28-7990049N2144WHansen Kenneth L · Kimballton, IABuilt 1979 · S/N 28-7916331N2145MHanscom Afb Aero Club · Hanscom Afb, MAS/N 28R-7837069N2147GAviation Capital Management LLC · San Jose, CABuilt 1978 · S/N 28-7916178N21481Houston Christopher T · Webster, NYBuilt 1978 · S/N 28-7916044N21489D & S Aviation LLC · Spring, TXBuilt 1978 · S/N 28-7990050N2148ZMalburg Phillip E · Holland, MIBuilt 1979 · S/N 28-7916378N2149ZBauer Jeff C · North Falmouth, MABuilt 1980 · S/N 28-7916380N214RAJw Aero Holdings Inc · Canandaigua, NYBuilt 1976 · S/N 28-7690440N2150FShoreline Aviation Inc · Marshfield, MABuilt 1978 · S/N 28-7916186N2150YGoldstein Orpaz · Woodland Hills, CABuilt 1979 · S/N 28-7916360N2150ZHilton Head Flyers LLC · Liberty, SCBuilt 1979 · S/N 28-7916382N21522Hove Paul · St Paul, MNBuilt 1978 · S/N 28-7916046N2152AWojtowicz Jacek A · Rhinebeck, NYBuilt 1978 · S/N 28-7916099N2152ZN2152z LLC · Middletown, DEBuilt 1979 · S/N 28-7916383N2154FGentile Nicholas J · Spring Grove, PABuilt 1978 · S/N 28-7990203N2157BMesheryakov Roman · Jacksonville, FLBuilt 1978 · S/N 28-7916113N2157YRegistration Pending · Northampton, MARegistration pendingBuilt 1979 · S/N 28-7990376N2158ZTribute Aero LLC · Rochester, MIBuilt 1979 · S/N 28-7990403N2159HBeverly Flight Center LLC · Middleton, MABuilt 1978 · S/N 28-7916192N2159QWisconsin Aviation-Four Lakes Inc · Madison, WIBuilt 1979 · S/N 28-7916282N215UParagon Airplane Leasing Co · Fort Myers, FLBuilt 2023 · S/N 28020136N215ZAlpha Tango Aircraft LLC · Wilmington, DEBuilt 2023 · S/N 2881607N21605Chandler Air Service Inc · Chandler, AZBuilt 1978 · S/N 28-7990054N2163GWilson Willard III · Cannon Falls, MNBuilt 1978 · S/N 28-7990194N2164GAulton New Energy Inc · Monterey, CABuilt 1978 · S/N 28-7990195N2165BCondor LLC · Cumberland, RIBuilt 1978 · S/N 28-7990122N2165HQuin Air Inc · Shreveport, LABuilt 1978 · S/N 28-7990210N2166BScroggs Ross A · Locust Grove, GABuilt 1978 · S/N 28-7990123N2166FUniversity Of Oklahoma · Norman, OKBuilt 1978 · S/N 28-7916208N2166LNefc Inc · North Andover, MABuilt 1979 · S/N 28-7990259
Back to AD 2016-07-21