Skip to content

Registered aircraft · 40,471

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:80-04-03-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:80-04-03-R2') 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:80-04-03-R2')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:80-04-03-R2')
  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:80-04-03-R2')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:80-04-03-R2')
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.

N810DAMjh Aero Inc · Houston, TXBuilt 1978 · S/N 28-7816427 N810FSModi Yogini · Homestead, FLBuilt 1979 · S/N 17272297 N810MATody Mark H Sr · Grand View, WIBuilt 1967 · S/N 28-23846 N810SUApm Leasing LLC · Casper, WYBuilt 1979 · S/N 17272319 N81103Reding Thomas M Jr · Taft, TXBuilt 1977 · S/N AA5B0430 N81104Barber Bradly · Metamora, MIS/N AA5B0431 N8110CMarcy Jonathan S Trustee · Newberry, SCBuilt 1975 · S/N 28-7615078 N8110FRobinson Ronald G · Ottawa, ILBuilt 1976 · S/N 28-7790234 N8110WJanczura Boguslaw S · Park Ridge, ILBuilt 1965 · S/N 28-2210 N81112Odyssey Flyers LLC · Kalispell, MTBuilt 1977 · S/N AA5B0433 N8111TRoy David J Sr · Summerland Key, FLS/N 17556811 N8111UTarkki Jarmo O · Solvang, CABuilt 1964 · S/N 17252011 N81124Harding Andrew · Milwaukie, ORBuilt 1977 · S/N AA5B0435 N8112JRamsey Douglas Edward · Monument, COBuilt 1979 · S/N 28-8090124 N8112QLongbranch Av8r LLC · Santa Rosa Beach, FLBuilt 1979 · S/N 28-8090125 N8112WTomerlin Danny · Pulaski, TNBuilt 1965 · S/N 28-2214 N81133Rafiq Abrahem · San Diego, CABuilt 1979 · S/N 28-8090133 N8113DHedditch David R · Victor, MTBuilt 1957 · S/N 22-5603 N8113HT4 Aviation LLC · Nine Mile Falls, WABuilt 1979 · S/N 28-8090129 N8113KSalmon River Assets LLC · The Woodlands, TXBuilt 1979 · S/N 28-8090130 N8113PJohnston Consulting Inc · Virginia Beach, VABuilt 1962 · S/N 24-3363 N8113RShenk Steven S · Strasburg, PABuilt 1979 · S/N 28-8090131 N8113WPridmore Joseph P · Columbus, MSBuilt 1965 · S/N 28-2217 N8113XOsage Air Service Inc · Bridgeton, MOBuilt 1979 · S/N 28-8090132 N81140Ellison Jason Todd · Pelham, ALBuilt 1977 · S/N AA5B0437 N81147Rolfe Benjamin A · Boulder Creek, CABuilt 1977 · S/N AA5B0438 N81149Fly By Knight Inc · Hammond, LABuilt 1982 · S/N 28-8216110 N8114ASummers Spraying Service Inc · Midland, TXBuilt 1979 · S/N 28-8090135 N8114DFarago John A · Grapevine, TXS/N 22-5605 N8114EGonser Albert L · White Hills, AZBuilt 1959 · S/N 1385 N8114FFlying Country Club Inc · Coal Valley, ILBuilt 1979 · S/N 28-8090136 N81155Tiger Bird Corp · Port Charlotte, FLBuilt 1977 · S/N AA5B0442 N81158Huber Aviation LLC · South Miami, FLBuilt 1977 · S/N AA5B0443 N8115BBlue Horizons Flying Club Inc · Perrysburg, OHBuilt 1979 · S/N 28-8016116 N8115DOsborne Richard Tyler · Anderson, SCBuilt 1957 · S/N 22-5606 N8115HRivera Philip T · Las Vegas, NVS/N 28-8016117 N8115LDouble Greene LLC · Spout Spring, VABuilt 1979 · S/N 28-8016119 N8115PJla Aero LLC · State College, PABuilt 1979 · S/N 28-8016120 N8115WBaity Robert G · Yadkinville, NCBuilt 1965 · S/N 28-2219 N81164Jww Flying Inc · Lakeland, FLBuilt 1977 · S/N AA5B0444 N81166Lou Dennis C · Los Altos, CABuilt 1977 · S/N AA5B0445 N8116BAronbay LLC · Bartlett, ILBuilt 1979 · S/N 28-8016124 N8116JChapel Hill Flying Club Inc DBA · Sanford, NCBuilt 1979 · S/N 28-8016125 N8116WKilbourne Garrot · Porum, OKS/N 28-2222 N81177Barrett Jc · Jefferson, GABuilt 1977 · S/N AA5B0448 N81181Registration Pending · Sacramento, CARegistration pendingBuilt 1977 · S/N AA5B0449 N81182Couch Sherman R · West Chester, OHBuilt 1977 · S/N AA5B0450 N81183Registered aircraftBuilt 1977 · S/N AA5B0451 N8118WHenson Anthony · Jasper, ALBuilt 1965 · S/N 28-2224 N8119BChabrier Pierre H · Wesley Chapel, FLBuilt 1982 · S/N 28-8290092

Back to AD 80-04-03 R2