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.

N914PACoco Aircraft Inc · Merritt Island, FLBuilt 1999 · S/N 2843303 N914RFHbe Aviation LLC · Salem, VABuilt 1980 · S/N 32R-8029054 N9150WMcmullin Chad D · Roosevelt, UTS/N 28-10777 N9150YTyler Transport LLC · Troy, ALBuilt 1985 · S/N 32R-8513009 N9151NPlane Nonsense Inc · Middletown, DEBuilt 1988 · S/N 2890090 N9152KHangar 9 Inc · Aberdeen, SDBuilt 1976 · S/N 28-7615179 N9152WTeal Water Investments LLC · Blanco, TXBuilt 1966 · S/N 28-10784 N9153JRamer Kristina · Ruskin, FLBuilt 1988 · S/N 2811021 N9155WWiger Theodore L · Falcon Heights, MNBuilt 1966 · S/N 28-10787 N9156JChristian Family Fellowship · Mesa, AZS/N 28-3213 N9157WFear David L · Hartford City, INBuilt 1966 · S/N 28-10773 N9158WKirkhoff Robert A · Pottstown, PABuilt 1966 · S/N 28-10832 N9159KRoss Andrew · Yamhill, ORBuilt 1976 · S/N 28R-7635223 N9159WDodson International Parts Inc · Rantoul, KSBuilt 1966 · S/N 28-10778 N915GArcher Flight LLC · Wilmington, DEBuilt 2018 · S/N 2881073 N915PABird Acquisition LLC · Phoenix, AZBuilt 1999 · S/N 2843304 N915TTLake Elmo Aero LLC · Lake Elmo, MNBuilt 1977 · S/N 28-7890158 N915WMChambers David N · Cullman, ALBuilt 1976 · S/N 28-7310107 N9160JMohan Aditya · Rancho Cordova, CAS/N 28-3218 N9160WAmerican Aviator LLC · Arlington, TXBuilt 1966 · S/N 28-10779 N9161JNortheast Nebraska Aviators Inc · Wayne, NEBuilt 1966 · S/N 28-3220 N9162JHillelson Lawrence E · Grosse Ile, MIBuilt 1966 · S/N 28-3221 N9162WYanka Anthony Joseph · Moorestown, NJBuilt 1968 · S/N 28-11096 N91630Skylink Xpress Inc · San Bernardino, CAS/N 2841055 N91631Seale Taylor Edward · Madison, WIBuilt 1993 · S/N 2890177 N91634Tharp Anthony W · Charleston, WVBuilt 1993 · S/N 2890178 N9163JCavu Flight Training LLC · Freeport, MEBuilt 1966 · S/N 28-3222 N9163WMetsker Kay B · Winnemucca, NVBuilt 1966 · S/N 28-10788 N9163ZTrident Aircraft Inc · Easton, MDBuilt 1989 · S/N 2841056 N9164JArizona Airbourne LLC · Gilbert, AZBuilt 1966 · S/N 28-3224 N9165KCasey Matthey J · Sedalia, COBuilt 1989 · S/N 2890104 N9165NJrh LLC · Indianapolis, INBuilt 1989 · S/N 3213020 N9165WPaleveda Michael · Riverview, FLBuilt 1967 · S/N 28-10790 N9166JRed Rock Flying School LLC · Mesa, AZBuilt 1966 · S/N 28-3226 N9167WBas Part Sales LLC · Greeley, COBuilt 1966 · S/N 28-10821 N9168J2binc LLC · Adrian, MIBuilt 1966 · S/N 28-3229 N9169WPutz Michael · Mesa, AZBuilt 1966 · S/N 28-10823 N916HPNeustaeter Pedro Thiessen · Anthony, NMS/N 28-2658 N916JFHammett Gary N · Prince Frederick, MDBuilt 1974 · S/N 28-7405130 N916PASkywest Leasing Inc · St George, UTBuilt 1999 · S/N 2843305 N916TTReyes-Hernandez Jose R · San Juan, PRBuilt 1989 · S/N 2841146 N9170WWyatt Jeffrey Ron · Lubbock, TXBuilt 1966 · S/N 28-10825 N9171JRichardson Adam D · Franklin, INBuilt 1966 · S/N 28-3232 N9172YMohammadreza Sabzi · Los Angeles, CABuilt 1985 · S/N 28-8616034 N9174JOrleans Flying Club Inc · Orleans, INBuilt 1966 · S/N 28-3238 N9174MParis Air Inc · Vero Beach, FLBuilt 1985 · S/N 28-8616035 N9174WKwan Andrew W · Lynnwood, WABuilt 1966 · S/N 28-10829 N9175GRepelatron Skyway LLC · Wilmington, DEBuilt 1989 · S/N 3206051 N9175JSommer Eric M · London, OHBuilt 1966 · S/N 28-3241 N9175WHamilton Lee A · Franklin, INBuilt 1966 · S/N 28-10830

Back to AD 87-08-08 R3