Skip to content

Registered aircraft · 22,413

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.

N6622WBayko John T · Marengo, OHBuilt 1965 · S/N 28-20718 N6623JAcadian Aviation Pilot Training Centre Inc · Lafayette, LAS/N 28-5090 N6624JN6624 LLC · Reserve, LABuilt 1968 · S/N 28-5091 N6625JJustice Andrew C · Amory, MSBuilt 1968 · S/N 28-5092 N6625WR W Bright Architects Inc · Tulsa, OKBuilt 1965 · S/N 28-20722 N6626JSn Aviation LLC · Richardson, TXBuilt 1968 · S/N 28-4919 N6627JYellowstone Flying Club · Billings, MTBuilt 1968 · S/N 28-4927 N6627WSemprimoznik Jeffery J · Davenport, WABuilt 1965 · S/N 28-20724 N6628WFigueroa Ruben E · Las Vegas, NVBuilt 1965 · S/N 28-20725 N6629FCloud10 Aviators LLC · Benton, LABuilt 1976 · S/N 32-7700003 N6629WWilcox Chris M · Canajoharie, NYBuilt 1965 · S/N 28-20726 N662APiper Archer Three LLC · Wilmington, DEBuilt 2014 · S/N 2843774 N662NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2019 · S/N 2881149 N662TFAir Fleet Holdings LLC · Missoula, MTBuilt 2025 · S/N 2881962 N6630WRiggin Flight Service Inc · Madison, SDS/N 28-20728 N6631FYah Inc · Wilmington, DEBuilt 1976 · S/N 32R-7780033 N6631WRegistration Pending · Arbela, MORegistration pendingBuilt 1965 · S/N 28-20729 N6633JBailey Randall D · Oakley, MIS/N 28-5099 N6633WSyf LLC · Okmulgee, OKBuilt 1965 · S/N 28-20731 N6634JMaier Robert B · Duncanville, TXBuilt 1968 · S/N 28-5101 N6635JIndian Head Flying Club LLC · Indian Head, MDBuilt 1968 · S/N 28-5102 N6637JCaison Rodney D · Carrollton, VABuilt 1968 · S/N 28-5105 N6638WTugmon Danny · Locust Grove, OKBuilt 1965 · S/N 28-20737 N6639JColoski Dennis J · Marlton, NJBuilt 1968 · S/N 28-5106 N663AFSnelling Peter G · Thornton, PABuilt 1981 · S/N 28-8290060 N663NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2020 · S/N 2881288 N663WTSkywest Leasing Inc · St George, UTBuilt 1998 · S/N 2843128 N6640JHeesch Donald · Nunn, COS/N 28-5107 N6640WAldrich David G · Naples, FLBuilt 1965 · S/N 28-20739 N6641JStratus Business Development LLC · Nashua, NHBuilt 1968 · S/N 28-5109 N6642JFive By Ten LLC · Loveland, COBuilt 1968 · S/N 28-5110 N6642WBrown Kevin D · Saint Louis, MOBuilt 1965 · S/N 28-20742 N6643JJohnson Steve · Attleboro, MABuilt 1968 · S/N 28-5111 N6643WWeiss Stephan T · San Jose, CABuilt 1965 · S/N 28-20743 N6645JMcdonald Neill F Jr · Fairfax, VABuilt 1968 · S/N 28-5131 N6645WHolman Robert S · Delta, UTBuilt 1965 · S/N 28-20745 N6646JNoize Farm Inc · Cheyenne, WYBuilt 1968 · S/N 28-5133 N6646WCordova Jesse · Raymore, MOS/N 28-20746 N6647WPanama Truck Line LLC · Florissant, MOBuilt 1965 · S/N 28-20748 N6649JBowline Ray D · Salina, OKBuilt 1968 · S/N 28-5064 N664FLElon Aviation LLC · Burlington, NCBuilt 1971 · S/N 28-7125586 N665Hamrick Gary L · Willshire, OHBuilt 1973 · S/N 28-7410034 N6650JCarolian Aviation LLC · Bexley, OHBuilt 1968 · S/N 28-5076 N6650WCole Alexander G · Leander, TXBuilt 1965 · S/N 28-20751 N6651WPeeples Timothy W · Griffin, GAS/N 28-21277 N6652FCrosswind Aviation Inc · Oakley, KSS/N 28-7725076 N6652WLumley John J · Delray Beach, FLBuilt 1965 · S/N 28-20754 N6654FRed River Aviators Flying Club · Bossier City, LAS/N 28-7715173 N6654WKosko Stanley G · Seattle, WABuilt 1965 · S/N 28-21279 N6655JLaukkanen Heikki J · Camas, WABuilt 1968 · S/N 28-5139

Back to AD 87-08-08 R3