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.

N8297WTraxler Christopher L · Reading, PABuilt 1965 · S/N 28-2462 N8298LCenturion Flight Services Inc · Grass Valley, CABuilt 1980 · S/N 28R-8131028 N8298MTech Site Air LLC · Plain City, OHBuilt 1980 · S/N 28-8111025 N8298TMilonnet Michel · Somerville, NJS/N 28-8111026 N8298WDonovan Jim · Georgetown, TXBuilt 1980 · S/N 28-8111027 N8299TAllens Plumbing Inc · Kahului, HIS/N 32-8106016 N8299VKoushall Marlon S · Finksburg, MDBuilt 1980 · S/N 32R-8113014 N829CJetran LLC · Horseshoe Bay, TXBuilt 2005 · S/N 3255039 N829JSRedstone Arsenal Flying Activity · Huntsville, ALBuilt 2001 · S/N 2842123 N829LSStarkys Equipment Leasing LLC · Manchester, MIBuilt 1988 · S/N 3213011 N82BZTeuber Gary J · Sister Bay, WIBuilt 1982 · S/N 28-8390017 N82DFVeritas Aviation LLC · Kalispell, MTBuilt 1981 · S/N 32-8206003 N82EBBogner Edward R Trustee · Santa Cruz, CABuilt 1978 · S/N 32R-7985028 N82JJHarrison Jeffrey · Orange Park, FLS/N 28R-8031125 N82KTK-T Industries Inc · Sheldon, IAS/N 32R-8129072 N82WHReed Joshua · Chesapeake, VABuilt 1981 · S/N 32R-8213026 N83009Paris Air Inc · Vero Beach, FLS/N 28-8116088 N8300JHepper Abby · Keene, NDBuilt 1980 · S/N 32R-8129010 N8300RBodner Michael J · Rock Hill, SCBuilt 1966 · S/N 28-22168 N83013Tjmc LLC · Riverbank, CABuilt 1980 · S/N 28-8116090 N83016Maks97 LLC · Sparta, MIBuilt 1980 · S/N 28-8116091 N8301CBeach Aero LLC · Virginia Beach, VABuilt 1975 · S/N 28R-7635144 N8301FSorensen Daryl · Presque Isle, MIBuilt 1982 · S/N 32-8306004 N8301LD M S Air LLC · Orlando, FLS/N 28R-8131035 N8301W01w Aero LLC · Conway, ARBuilt 1965 · S/N 28-2466 N83021Kosbruk Boris R Jr · Perryville, AKBuilt 1980 · S/N 28-8190104 N83029Travis Aviation LLC · Jacksonville, TXS/N 28-8311005 N8302A4 Moons Aviation Inc · Danvers, MABuilt 1980 · S/N 28-8116092 N8302CAcey Joseph P · Macomb, MIBuilt 1975 · S/N 28-7610073 N8302RHofmann Richard C · Keizer, ORFirst renewal noticeBuilt 1966 · S/N 28-22079 N8302TYarb LLC · Cleburne, TXBuilt 1980 · S/N 28-8190103 N8302WNaccarato Aviation LLC · Woodstock, GABuilt 1965 · S/N 28-2467 N83038Zimin Transportation LLC · South Naknek, AKBuilt 1980 · S/N 28-8116096 N83039Macair Aviation LLC · Xenia, OHBuilt 1980 · S/N 28-8116097 N8303DPhoenix Mooney LLC · Vista, CABuilt 1981 · S/N 28-8111032 N8303QDucota 6 LLC · Jasper, INBuilt 1982 · S/N 28-8311006 N8303WIrwin Jerome C · Anchorage, KYS/N 28-2468 N83047Gullo Michael · Voorhees, NJS/N 28R-8131038 N8304KKrouse James · Cocoa Beach, FLS/N 28-8190107 N8304LGarrai LLC · Rhinebeck, NYS/N 28-8190108 N8304NSmith Steven Thomas · Gosnell, ARBuilt 1980 · S/N 28R-8118033 N8304RKnots And Attitudes LLC · Wimberley, TXBuilt 1966 · S/N 28-22171 N8304WCassin William J · Uvalde, TXBuilt 1965 · S/N 28-2471 N83052Green Richard M DBA · Lighthouse Point, FLS/N 32-8306006 N8305LPipsara LLC · Jacksonville, FLBuilt 1980 · S/N 32-8106018 N8305WEllefson Aircraft LLC · Tyler, MNBuilt 1980 · S/N 32-8124002 N8306CCoolidge Oliver · Downers Grove, ILBuilt 1975 · S/N 28-7625100 N8306EBreidenbach Any · Onalaska, WIBuilt 1980 · S/N 32R-8129014 N8306RPernula Jacob D · Mount Vernon, WABuilt 1966 · S/N 28-22175 N8307Prather Gregory Douglas · Boca Raton, FLBuilt 1980 · S/N 32R8113017

Back to AD 87-08-08 R3