Skip to content

Registered aircraft · 22,411

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.

N208GGPenn Yan Flying Club Inc · Penn Yan, NYBuilt 1975 · S/N 28-7690073 N208THN208th LLC · Villa Rica, GAS/N 3246122 N2090RRubright Erik M · Gladstone, MIBuilt 1969 · S/N 28-4975 N2090VWater Sports Unlimited · Griffin, GABuilt 1979 · S/N 28-7990339 N2091BRegistered aircraftBuilt 1978 · S/N 28-7990117 N2091DRegistration Pending · Magnolia, TXRegistration pendingBuilt 1978 · S/N 28-7916141 N2091MGreat Planes Aviation Inc · Rochester, MNS/N 28-7816249 N2091PStahler Corporation Ltd · Bexley, OHBuilt 1979 · S/N 32-7940041 N2091VAircraft Partners LLC · Owensboro, KYBuilt 1979 · S/N 28R-7931108 N2091WDestefano Patrick · Adamsville, TNS/N 28R-7918076 N20928Shelley Aaron J · Corbin, KYBuilt 1978 · S/N 32R-7887182 N2092AKimmons Anthony J · Quitman, TXBuilt 1978 · S/N 28-7916094 N2092CElam Nathan A · Hereford, TXBuilt 1978 · S/N 28-7911020 N2092DSelchow Stuart · Plato, MNBuilt 1978 · S/N 28-7911032 N2092MRegistration Pending · Augusta, KSRegistration pendingS/N 28-7816250 N2092TCarrolls Auto And Aircraft Sales LLC · Muncie, INBuilt 1971 · S/N 28R-7135037 N2092XAirx LLC · Warwick, RIBuilt 1979 · S/N 28-7916342 N2093CJerles William R Jr · Roberta, GABuilt 1978 · S/N 32R-7985022 N2093MAir Cortright LLC · Boyne City, MIBuilt 1977 · S/N 28-7890228 N2093TRollins Wesley F · Clover, SCBuilt 1970 · S/N 28R-7135038 N2093XWord Kyle Remington · Albuquerque, NMBuilt 1979 · S/N 28-7911140 N2094PCampbell John A · Brentwood, TNBuilt 1979 · S/N 32R-7985077 N2094ROtt Rusty S · Sugar Grove, ILS/N 28-5459 N2094TSuzuki Yoshinori · Ames, IABuilt 1970 · S/N 28R-7135039 N2094VCorning James Elmon · Flagstaff, AZS/N 28R-7931109 N20958Ras Aviation LLC · Elyria, OHBuilt 1978 · S/N 28-7916020 N2095VMoon Christopher · Guyton, GABuilt 1979 · S/N 28R-7931110 N2095WOnnoh Fred · Oak Harbor, WABuilt 1979 · S/N 28R-7918077 N2096ARegistration Pending · Malden, MORegistration pendingBuilt 1978 · S/N 32R-7985001 N2096BN2096b LLC · Buffalo, NYBuilt 1978 · S/N 28-7911008 N2096LMcfarland Bruce R · Newberry, FLBuilt 1978 · S/N 28-7916242 N2096TDufur Casey L · Durant, OKBuilt 1971 · S/N 28R-7135041 N2096XSeward Mark · Seattle, WABuilt 1979 · S/N 28-7921007 N2097MDm Asset Management LLC · Plain City, OHS/N 28-7890229 N2097NSidney Flying Club Inc · Sidney, OHBuilt 1979 · S/N 28-7916257 N2097UNorris Barry D · Soquel, CABuilt 1979 · S/N 28-7916311 N20985Aero X Flying Club Inc · Winchester, VAS/N 28-7990029 N2098TIsaacs Brandon · Homedale, IDBuilt 1971 · S/N 28R-7135043 N2099Paragon Airplane Leasing Co · Fort Myers, FLBuilt 2024 · S/N 28020179 N20992Sketo Aviation LLC · Bardstown, KYBuilt 1978 · S/N 28-7990030 N2099TArrowmark LLC · Schroeder, MNBuilt 1971 · S/N 28R-7135044 N209JRegistered aircraftBuilt 1982 · S/N 28-8216153 N209SCInternational Air Services Inc Trustee · Carson City, NVBuilt 1976 · S/N 28-7625115 N20AZDelta Juliet Wings LLC · Kennesaw, GABuilt 1979 · S/N 28-7911153 N20BBlackard William R Jr · Jacksonville, FLBuilt 1976 · S/N 32R-7680387 N20BWN220kw LLC · Moses Lake, WABuilt 1976 · S/N 32R-7680355 N20GGHofer Danny C · Huron, SDBuilt 1978 · S/N 28-7916032 N20JMWaeltz Mark A · Lantana, FLBuilt 1967 · S/N 28-4393 N20LGYerena Mario Cesar Gutierrez · Bethel Island, CABuilt 1968 · S/N 28R-30491 N20LLFlying 20 Club Inc · Springfield, ILBuilt 1978 · S/N 28-7990119

Back to AD 87-08-08 R3