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.

N8792EMann Joshua A · Montgomery, TXBuilt 1976 · S/N 32R-7680178 N8792NPiotrowski Nicholas S · Poplar Grove, ILBuilt 1969 · S/N 28-25633 N8792WHale Mitchell D · Chugiak, AKBuilt 1964 · S/N 28-10340 N8794MPiper Associates LLC · Stanhope, NJS/N 2810342 N8794NCopeland Kevin D · Vidalia, GABuilt 1969 · S/N 28-25637 N8795NCycle-Moto Inc · Gilbert, AZBuilt 1969 · S/N 28-25639 N8795WKessel Run Holdings LLC · Seminole, FLBuilt 1964 · S/N 28-10343 N8796NMitchell Michael R · Swanville, MEBuilt 1969 · S/N 28-25640 N8796WRegistered aircraftBuilt 1964 · S/N 28-10345 N8797BDalton Robert Frank · Jackson, CAS/N 32-40149 N8797CMeadowlake Airpark LLC · Lenoir City, TNBuilt 1976 · S/N 32-7640071 N8797EVan Beckum Peter · Farmington, CTBuilt 1976 · S/N 28-7690209 N8797WBenson Marvin D · Bertrand, NEBuilt 1964 · S/N 28-10346 N8798EFuller Glenn C · Santa Paula, CAS/N 28R-7635215 N8798WGregory Cody A · Lamar, MOBuilt 1964 · S/N 28-10347 N8799NDuffe William B · Moscow, IABuilt 1969 · S/N 28-25643 N8799WFeller Gerald · Long Beach, CABuilt 1964 · S/N 28-10349 N87KGCherokee From Sebring LLC · North Brunswick, NJBuilt 1969 · S/N 28R-35043 N87MCNorthern Blue Skies Inc · Shawano, WIBuilt 1980 · S/N 28-8090104 N87WAltitude Aviation LLC · Lenoir, NCBuilt 1999 · S/N 2843296 N8800JRobinson Jacob · Lewistown, MTS/N 28-2745 N8801WAfrican Research Foundation Inc · New York, NYRevoked, canceledBuilt 1964 · S/N 28-10213 N8802JShivers James C II · Columbus, OHBuilt 1965 · S/N 28-2750 N8802WRegistration Pending · San Juan, PRRegistration pendingBuilt 1964 · S/N 28-10248 N8804JClosen David A · Comanche, TXS/N 28-2754 N8804NCarbon Regional Aero Club · Lehighton, PABuilt 1969 · S/N 28-25649 N8805J8805 Partners LLC · Oklahoma City, OKBuilt 1965 · S/N 28-2755 N8806JLytle Hugh R · Senoia, GABuilt 1965 · S/N 28-2756 N8806NHorne Terry A · Carefree, AZBuilt 1969 · S/N 28-25652 N8806WKennemer Mark · San Angelo, TXBuilt 1964 · S/N 28-10351 N8807JNorris Dana G III · Zanesville, OHS/N 28-2757 N8807NTruax James D · Roanoke, INBuilt 1969 · S/N 28-25653 N8807WSimon Randall V P · Fairbanks, AKBuilt 1966 · S/N 28-10803 N8808JCoulliette Brian K · Jacksonville, FLBuilt 1965 · S/N 28-2758 N8808WHolysz Matthew M · Vicksburg, MIBuilt 1964 · S/N 28-10353 N880PUPurdue University Trustees · West Lafayette, INBuilt 2025 · S/N 2881949 N880SCKc Hawgs Inc · Wilmington, DEBuilt 1979 · S/N 32R-8029015 N8810NShawl Robert M · Woodlake, CABuilt 1969 · S/N 28-25657 N8810WLayne Andrew P · North Port, FLBuilt 1964 · S/N 28-10355 N8813CUlrich Helmut Wiegand · Satellite Beach, FLBuilt 1976 · S/N 32R-7680140 N8813NLangton Shane A · Boise, IDBuilt 1969 · S/N 28-25660 N8813WOntiveros Carlos E · Prescott, AZBuilt 1964 · S/N 28-10359 N8814FBas Part Sales LLC · Greeley, COBuilt 1976 · S/N 28-7790268 N8814JCarey H Dwain · Cheyenne, WYBuilt 1965 · S/N 28-2766 N8814NMarshall Lance A · Portland, ORBuilt 1969 · S/N 28-25661 N8815NJenkins Roger Clayton II · Plain Dealing, LABuilt 1969 · S/N 28-25663 N8816JHuff Roger A · Johnstown, OHBuilt 1965 · S/N 28-2770 N8817CSharon Ricky E · Roberta, GABuilt 1976 · S/N 28-7625132 N8817JMy Bird Is Bigger Than Yours LLC · Fort Myers, FLBuilt 1965 · S/N 28-2771 N8819ETransition Aviation LLC · Hummelstown, PABuilt 1976 · S/N 28R-7635209

Back to AD 87-08-08 R3