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.

N1809HAviation Consulting Expertise LLC · Fairfax Station, VAS/N 28-7790314N181AEDavis Timothy Alan · Huntsville, ALBuilt 1977 · S/N 28-7890235N181AVElkins Pilots Club · Elkins, WVBuilt 1979 · S/N 287990269N181BAClough James Erwin · Pittsboro, NCBuilt 1981 · S/N 28-8116230N181BHAeronation Aircraft & Exotics LLC · Lewes, DEBuilt 1982 · S/N 28-8390003N181DJNew England Aviation LLC · Plainville, CTBuilt 1977 · S/N 28-7790415N181FATriangle Aviators LLC · Cary, NCBuilt 1983 · S/N 288390062N181FCFlightstar Corp · Savoy, ILBuilt 2000 · S/N 2843316N181GBBartel Gary W · Tucson, AZBuilt 1979 · S/N 28-7990275N181GPPilots Flying School LLC · Manalapan, NJBuilt 1984 · S/N 28-8490061N181HEOzziac Enterprises Inc · Huron, OHBuilt 1988 · S/N 2890078N181LSLee Jerry R · Fresno, CABuilt 1999 · S/N 2843227N181MHHurd Mark A · Bono, ARBuilt 1979 · S/N 28-7990279N181MRAverett University · Danville, VABuilt 1999 · S/N 2843223N181PDAnderson Christopher · Wilmington, NCBuilt 1978 · S/N 28-7890462N181PGSkybound Aviation LLC · Kernersville, NCBuilt 1977 · S/N 28-7790584N181RJUaa International Inc · La Verne, CABuilt 1980 · S/N 28-8190106N181TBVector Aviation LLC · Mentor, OHBuilt 1978 · S/N 28-7990212N181TCDezendorf Thomas C · Petaluma, CABuilt 1979 · S/N 28-7990324N181TKAnderson Brad A · Rochester, MNBuilt 1977 · S/N 28-7890193N181TPOssowski Gerald A · Orland Park, ILS/N 28-7790426N181TSJls Aviation LLC · Sarasota, FLBuilt 1975 · S/N 28-7690062N181WFNorton Thomas W · Dayton, NVBuilt 1977 · S/N 28-7890116N181WGFlycasual LLC · Bloomington, ILBuilt 1984 · S/N 28-8490069N181YTailwinds Aviation Academy LLC · Grass Valley, CAS/N 28-8590089N1820H5c1 Jet Center LLC · Boerne, TXS/N 28-7716053N1822HAdvanced Aviation Group LLC · Frederick, MDBuilt 1977 · S/N 28-7790345N1824HAthar Glenola LLC · Mars, PABuilt 1977 · S/N 28-7790346N183CFCherokee Flyers Inc · Vero Beach, FLBuilt 1999 · S/N 2843232N184BWDevuono Derin D · Pocono Lake, PABuilt 1979 · S/N 28-7916345N184CFPiper Aircraft Inc · Vero Beach, FLBuilt 1999 · S/N 2843242N184JDRegistered aircraftBuilt 1977 · S/N 28-7790567N184LGAb Prop Plane I LLC · Metairie, LAS/N 2881908N184TCTexas State Technical College · Waco, TXBuilt 2025 · S/N 28020240N1859AAverett University · Danville, VABuilt 2022 · S/N 2881527N185LHPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28010066N1869RHarwood John · Waxahachie, TXBuilt 1975 · S/N 28-7690060N186KBAims Community College · Greeley, COBuilt 2018 · S/N 2881086N186PPiper Aircraft Inc · Vero Beach, FLS/N 28020293N186SPClear2 Aviate LLC · Ionia, MIBuilt 1977 · S/N 28-7790514N187ARPiper Aircraft Inc · Vero Beach, FLS/N 28010087N187FTTowater Ronnie A · Ocala, FLS/N 28-8216197N187SDHelo-Max LLC · Dublin, GABuilt 1989 · S/N 2841065N187SPFarwick Brent T · Louisville, TNBuilt 1977 · S/N 287790372N187TPR G R Holdings LLC · Spring Branch, TXBuilt 2006 · S/N 2843627N188DXPiper Aircraft Inc · Vero Beach, FLS/N 28010104N189CSHelo-Max LLC · Dublin, GABuilt 2021 · S/N 28020039N189ECCollins Richard · Oceanside, NYS/N 28-8290061N189JBSpin Off Aircraft LLC · West Palm Beach, FLBuilt 1979 · S/N 28-7990190N189SPKilpatrick Blake E · Canyon Lake, TXS/N 28-8016137
Back to AD 2016-07-21