Skip to content

Registered aircraft · 22,416

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

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:87-08-08-R3') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-08-08-R3') ORDER BY n_number

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:87-08-08-R3')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-08-08-R3')
  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.

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:87-08-08-R3')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-08-08-R3')
ORDER BY n_number

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N8370WTaylor Tmothy P · Watford City, NDBuilt 1965 · S/N 28-2567 N8370YKdtb Investments LLC · Bangs, TXS/N 32R-8129062 N8371WDavis Kyle G · Weatherford, TXS/N 28-2568 N8372CMarino Robert · Little Neck, NYBuilt 1976 · S/N 28-7690125 N83734Willis Jason W · North Bend, OHS/N 28R-8131118 N8373CFinley Aviation LLC · Bethel Park, PABuilt 1976 · S/N 28-7690126 N8373DGolden Wings Aviation Inc · Brandenburg, KYBuilt 1981 · S/N 28-8116203 N8373WAmplified Aviation LLC · Cannelburg, INBuilt 1981 · S/N 28-8190214 N8373YArcher Assoc LLC · Ashburn, VABuilt 1981 · S/N 28-8190215 N83741Lenoir Dennis E · Cut Bank, MTBuilt 1968 · S/N 28-11143 N8374PFreeman James T · Elizabeth City, NCS/N 32-8106057 N8374TCarlos Sean N · Togiak, AKBuilt 1981 · S/N 32-8106058 N8374WMartin Rebecca · Bothell, WAS/N 28-2574 N8375CHammett Jeb Stuart · Monroe, LABuilt 1976 · S/N 32R-7680103 N8375RCarlton John B · Lenoir, NCBuilt 1966 · S/N 28-22252 N8375WSingh Harbans · Las Vegas, NVBuilt 1965 · S/N 28-2575 N83762Lansing Community College · Mason, MIBuilt 1981 · S/N 28R-8118065 N83763Stingerpower Inc · San Jose, CABuilt 1981 · S/N 32-8106062 N83764Sprouse Aviation LLC · Long Beach, CAS/N 32-8124024 N8376LPray Aviation Inc · Augusta, KSBuilt 1981 · S/N 28-8116205 N8376QBlanchard Mark H · Moultrie, GABuilt 1981 · S/N 28-8111063 N8376RRegistration Pending · Wshngtn Ct Hs, OHRegistration pendingBuilt 1966 · S/N 28-22253 N8376WSale Reported · Crystal, MNSale reportedS/N 28-2576 N83775Mattson Greg L · Alta, IABuilt 1981 · S/N 28-8190220 N8377GKristoferson J S Md Custodian · Denton, TXBuilt 1981 · S/N 32R-8113064 N8377RPerry Eden · Morgan Hill, CABuilt 1966 · S/N 28-22254 N8377WRosenberg Adam N · Scottsdale, AZBuilt 1965 · S/N 28-2578 N8378ASoutheast Wings Ltd · Winston, GABuilt 1981 · S/N 28-8116206 N8378BMathewson Leslie A · Knoxville, TNBuilt 1981 · S/N 28R-8118042 N8378CCuller Hall Aeronautics LLC · Morrow, OHBuilt 1976 · S/N 28-7615097 N8378HDiversified Aeronautical Svcs · Lake Ronkonkoma, NYBuilt 1981 · S/N 28-8116208 N8378RNachbar Scott G · Springville, NYBuilt 1966 · S/N 28-22255 N8379WChilds Electric Inc · Dawson, GABuilt 1965 · S/N 28-2580 N837NDUnd Aerospace Foundation · Grand Forks, NDS/N 2881290 N837PProfessional Training Aircraft LLC · Wilmington, DEBuilt 2018 · S/N 2843940 N837SCFf22 LLC · Scottsdale, AZBuilt 2024 · S/N 2881716 N83808Jcl Aviation Inc · Palm Harbor, FLBuilt 1981 · S/N 32R-8129065 N8380CPittsburgh Pilot Training LLC · Bethel Park, PABuilt 1976 · S/N 28-7690127 N8380LTroser Management Inc · Canandiaigua, NYBuilt 1981 · S/N 28-8190222 N8380PGoins Eric M · Goldsboro, NCBuilt 1981 · S/N 28-8190223 N8380WForbes Aviation LLC · Boise, IDS/N 28-2582 N83814Wachter Bruce · Maryville, TNBuilt 1981 · S/N 28-8116218 N8381CIsley Gaylon B · Cedar Falls, IABuilt 1976 · S/N 28-7690128 N8381VAurora Direct LLC · West Linn, ORBuilt 1981 · S/N 32-8124025 N8382AAtd Pilot Training LLC · Kansas City, MOBuilt 1981 · S/N 28-8190228 N8382CSwickert Donald L II · Merritt Island, FLBuilt 1976 · S/N 28R-7635154 N8382TPhoreman James Jr · Lancaster, CABuilt 1981 · S/N 28R-8118068 N8382WTrans Western Air Inc · Cullowhee, NCBuilt 1965 · S/N 28-2584 N8382ZMueller Charles G · Naples, FLBuilt 1981 · S/N 28-8111064 N83831Connelly Christopher J · Lewiston, NYBuilt 1981 · S/N 28-8190233

Back to AD 87-08-08 R3