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.

N55380Clark Joseph David · Kilgore, TXS/N 28-7325388 N55383Winkelman James R · Zionsville, INBuilt 1973 · S/N 28-7305371 N5538UAircraft Sales LLC · Caledonia, MIBuilt 1969 · S/N 28-26260 N55390Davis Hunter · Winters, TXBuilt 1973 · S/N 28-7310134 N55392Fast Aircraft Aerowork Corp · Fort Lauderdale, FLNon-citizen corporation, flight hours not reportedBuilt 1973 · S/N 28-7325391 N55397Stephens Ryan L · Gardner, ILBuilt 1973 · S/N 28-7305374 N5539FAeronautical Technical Service Inc · Collierville, TNBuilt 1968 · S/N 28-24938 N5539JCarr Paul · Ottumwa, IAS/N 32-1000 N5539UDickey Blaine K · Marion, ARBuilt 1969 · S/N 28-26261 N553FLWalters Rande L Sr · Lock Haven, PABuilt 1971 · S/N 28-7125392 N553PUSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2000 · S/N 2842090 N553SCSpartan Education LLC · Tulsa, OKBuilt 2020 · S/N 2881342 N553TPOakland Flyers LLC · Oakland, CABuilt 1975 · S/N 28-7690105 N55401Keesling Roger · Starkville, MSBuilt 1973 · S/N 28-7325405 N55402Gleason Scot · Hayden, IDBuilt 1973 · S/N 28-7325395 N55407Yeager Bradley William · New Market, ALBuilt 1973 · S/N 28-7305377 N5540JLesser Antilles Corp Trustee · Wilmington, DEBuilt 1968 · S/N 32-1003 N5540UEvans Thomas Patrick · Hollow Rock, TNBuilt 1969 · S/N 28-26262 N5540WAir-Crete Constructions Inc · Lake Elmo, MNBuilt 1962 · S/N 28-631 N55416Cox David S · Elizabethtown, KYBuilt 1973 · S/N 28-7325397 N55419Kinneberg Russell · Plymouth, MNBuilt 1973 · S/N 28-7305380 N5541URegistered aircraftS/N 28-26263 N5541WKauffman Duane N · Sarasota, FLBuilt 1962 · S/N 28-632 N55421Burton Tucker · Moberly, MOBuilt 1973 · S/N 28-7305381 N55423Prescott Flying Club Inc · South Saint Paul, MNBuilt 1973 · S/N 28R-7335231 N55428Flight Gear Aviation LLC · Pickerington, OHBuilt 1973 · S/N 28-7325399 N5542FColtman Graham E · Colleyville, TXBuilt 1968 · S/N 28-24941 N5542WAdvanced Airplanes Associates Inc · Keller, TXBuilt 1962 · S/N 28-633 N55433Thrasher Aviation LLC · Bartonsville, PABuilt 1973 · S/N 28-7305384 N5543FPantelias George · Astoria, NYBuilt 1968 · S/N 28-25240 N5543SCascade Marine Holdings Inc · Terrebonne, ORBuilt 1978 · S/N 32R-7887031 N5543UAckerman Richard K · Ponce De Leon, FLBuilt 1969 · S/N 28-26266 N5543WTerpe Roberto Palomera · Sedro Woolley, WABuilt 1962 · S/N 28-634 N55441Airide Enterprise LLC · Dixon, MOBuilt 1973 · S/N 28-7310139 N55449Syracuse Flight School Inc · Syracuse, NYBuilt 1973 · S/N 28-7325406 N5544FRenfro Michael W · Bethel, AKBuilt 1976 · S/N 32R-7780014 N5544WMatlack Mark R · Saint Bonifacius, MNS/N 28-635 N55450Conway Global LLC · Groom, TXBuilt 1973 · S/N 28-7305385 N55452Schroeder William L · Sarasota, FLBuilt 1973 · S/N 28-7305387 N55458Challenger LLC · Amston, CTBuilt 1973 · S/N 28-7305389 N5545BLundsted Andrew S · Taylor Falls, MNBuilt 1973 · S/N 28R-7335236 N5545JMouat Michael Wayne · Hemet, CABuilt 1968 · S/N 32-1007 N5545UHewitt Robert J · Ringwood, NJBuilt 1969 · S/N 28-26268 N55460Nish Aviation LLC · Concord, NCBuilt 1973 · S/N 28R-7335237 N55462Riverside Pilots Inc · Riverside, CABuilt 1973 · S/N 28-7310141 N5546UWright Michael R · Bristol, FLBuilt 1969 · S/N 28-26269 N5546WThird Step 4 LLC · Gilbert, AZBuilt 1962 · S/N 28-637 N55470Ebersole Wayne D · Fairfield, MTBuilt 1973 · S/N 28-7325411 N55483Edisto LLC · Falls City, NEBuilt 1973 · S/N 28-7305395 N55484Yoder Sylvan R · Camilla, GABuilt 1973 · S/N 28R-7335241

Back to AD 87-08-08 R3