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.

N9338JCarr Shelby · Stevenson, ALBuilt 1966 · S/N 28-3435 N9338NForker Thomas S · Williamsport, PABuilt 1969 · S/N 28R-35038 N9339JTruesdell Michael L · Tonopah, NVS/N 28-3436 N933BKKreul Robert W · Waconia, MNBuilt 1971 · S/N 28-7225113 N933CC27 Latitude LLC DBA · West Palm Beach, FLBuilt 1979 · S/N 28-7990503 N933GCareer Pilot Training LLC · Wilmington, DEBuilt 2019 · S/N 2881224 N933SCAb Prop Plane I LLC · Metairie, LABuilt 2025 · S/N 2881873 N9340JLovelace Mario · Coral Springs, FLBuilt 1966 · S/N 28-3438 N9340N9340n LLC · Broken Arrow, OKBuilt 1969 · S/N 28R-35041 N9341CMerlin Aviation LLC · South Saint Paul, MNBuilt 1978 · S/N 28-7890399 N9341WSleigh Jonathan B · Upland, CAS/N 28-11027 N9342JDeschepper Sandra K · Independence, MOBuilt 1966 · S/N 28-3440 N9342WSmith Bradley W · St George, UTBuilt 1968 · S/N 28-11028 N9344JBiamonte Thomas John · Ventura, CABuilt 1966 · S/N 28-3442 N9344WEmery Nelson J · Emporia, KSBuilt 1967 · S/N 28-11031 N9345JGrady John O · West Chester, OHBuilt 1966 · S/N 28-3443 N9346JAhern Walter B · Durango, COBuilt 1966 · S/N 28-3444 N9346WRegistration Pending · Crosby, TXRegistration pendingBuilt 1968 · S/N 28-11033 N9347NDavis Braeden L · Blanchard, OKBuilt 1969 · S/N 28R-35048 N9348NPletcher Gayle L · Topeka, KSBuilt 1969 · S/N 28R-35049 N9349JPfingsten Leon R · Sheldon, NDBuilt 1966 · S/N 28-3447 N9349NStutzman Gary A · Watsontown, PAS/N 28R-35050 N934NDUniversity Of North Dakota · Grand Forks, NDBuilt 2025 · S/N 2881887 N934PHRossell Holdings LLC · Astoria, ORBuilt 1974 · S/N 32-7540059 N9350JElliott Peter J · Riverside, CABuilt 1966 · S/N 28-3448 N9350KPanjab Aviation · Las Vegas, NVBuilt 1976 · S/N 28R-7635233 N9350WBlock Scott M · Chandler, AZBuilt 1968 · S/N 28-11038 N9351JCoyote Flight Centers LLC · Amarillo, TXBuilt 1966 · S/N 28-3449 N9351NHess Garrett J · Fullerton, CABuilt 1969 · S/N 28R-35054 N9351WWurmbrand Stephan B · Westhampton, MABuilt 1968 · S/N 28-11103 N9352JDiorio Robert A · Redlands, CABuilt 1966 · S/N 28-3450 N9352WNistler Anthony Lamar · Mcgregor, MNBuilt 1968 · S/N 28-11040 N9353JNychka Robert J · Wills Point, TXBuilt 1966 · S/N 28-3451 N9354JLamb David S · Yuba City, CABuilt 1966 · S/N 28-3453 N9354NThurnau Daniel E · Kingston, ILBuilt 1969 · S/N 28R-35058 N9354WBlue Horizon Aircraft LLC · Wilmington, DEBuilt 1968 · S/N 28-11042 N9355WEngland Noah C III · Lowell, NCBuilt 1968 · S/N 28-11043 N9356JVali Air Service LLC · Livingston, MTBuilt 1966 · S/N 28-3455 N9356WOrtman Stephen B · Mill Creek, WABuilt 1968 · S/N 28-11045 N9357JKirchoff Jennifer L · Hamden, CTBuilt 1966 · S/N 28-3456 N9358CMiloud Chadd K · Fort Worth, TXBuilt 1978 · S/N 28-7816466 N9358WPena Evan M · San Antonio, TXS/N 28-11047 N9359NMorristown Flying Service Inc · Talbott, TNBuilt 1969 · S/N 28R-35066 N935DELong Island Aviators LLC · Seaford, NYBuilt 1978 · S/N 28-7990146 N935GArcher Flight LLC · Wilmington, DEBuilt 2018 · S/N 2881078 N9360CPure Joy Aviation One LLC · Schaumburg, ILBuilt 1978 · S/N 28-7890401 N9361WRadecki Louis J · Helenville, WIBuilt 1968 · S/N 28-11051 N9362CThanheiser Heige · Lincoln, NEBuilt 1978 · S/N 28R-7837193 N9362JSandy Bottom LLC · Nantucket, MABuilt 1966 · S/N 28-3461 N9362NPool Busters LLC · Lake Bluff, ILBuilt 1969 · S/N 28R-35069

Back to AD 87-08-08 R3