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.

N8358WChaney Eddie L · Douglas, GABuilt 1965 · S/N 28-2550 N8358ZMinella Frank A · Old Forge, PABuilt 1981 · S/N 28-8190192 N8359ESabrilyn Ventures LLC · The Villages, FLBuilt 1981 · S/N 28R-8131099 N8359MColeman Russell L · Port Charlotte, FLBuilt 1981 · S/N 32-8124019 N8359SSoda Aviation LLC · Lexington, KYBuilt 1981 · S/N 32-8124020 N8359WMarble Jere D · Dayton, NVBuilt 1965 · S/N 28-2551 N8359XW&H Services LLC · Boerne, TXBuilt 1981 · S/N 32R-8113055 N8360GSophamike Aviation LLC · Hattiesburg, MSBuilt 1981 · S/N 32R-8129057 N8360YOtto Aviation LLC · Gilbertsville, PABuilt 1981 · S/N 28-8190195 N83612Ort Mark P · Pickerington, OHBuilt 1981 · S/N 32R-8113059 N83615Brown Thomas E · Union Grove, ALBuilt 1981 · S/N 32R-8129058 N8361WBursch Clint Lee · Bird City, KSBuilt 1965 · S/N 28-2556 N8362RCore Flight Academy LLC · Asheboro, NCBuilt 1966 · S/N 28-22344 N8362WSexton Rick C · Payson, AZBuilt 1965 · S/N 28-2557 N8363EEllefson Aircraft LLC · Tyler, MNS/N 28-8116187 N8363HFox John · Asheboro, NCBuilt 1981 · S/N 28-8116188 N8363PLove Richard S · Indianapolis, INBuilt 1981 · S/N 28-8116191 N8363RHancock Allen L · Twentynine Palms, CABuilt 1966 · S/N 28-22239 N8363WRegistered aircraftBuilt 1965 · S/N 28-2558 N8363ZGobel Mario · Belleville, WIFirst renewal noticeBuilt 1981 · S/N 28-8190202 N8364CTurner Royce E · Bridgeport, WABuilt 1975 · S/N 28-7615094 N8364GMcintosh Warren K · Cookeville, TNBuilt 1981 · S/N 28-8190203 N8364RSwank Freeman J · Fort Myers, FLBuilt 1966 · S/N 28-22240 N8364VRodgers Keith E · Dover, PAS/N 28R-8118061 N8365RRegistration Pending · Lake City, FLRegistration pendingBuilt 1966 · S/N 28-22241 N8365WAbramczyk Randall L · Delta, OHBuilt 1965 · S/N 28-2562 N8365ZScorse Jeffrey A · Lunenburg, MABuilt 1981 · S/N 28-8116196 N8366NLakes Region Flying Club Inc · Gilford, NHBuilt 1981 · S/N 28-8190205 N8366RMoyer Jay R · Corry, PABuilt 1966 · S/N 28-22242 N8366ZApm Leasing LLC · Casper, WYBuilt 1981 · S/N 28-8190206 N83670Aerospace Trust Management LLC Trustee · Wilmington, DEBuilt 1981 · S/N 28-8190210 N8367CBuckwalter Daniel E · Homer, AKBuilt 1976 · S/N 32-7640061 N8367RNorthwest Roamers Inc · Eugene, ORBuilt 1966 · S/N 28-22243 N8367SBaer Donald J · Groton, CTBuilt 1981 · S/N 28-8190207 N8367WBreeze Through LLC · Brooklyn, NYBuilt 1965 · S/N 28-2564 N83685Hennen Roger · Sanger, TXS/N 28R-8118046 N8368COchoa Luis M · Hollywood, FLBuilt 1976 · S/N 32R-7680102 N8368RLive And Give Foundation Management Group LLC · Huntsville, TXBuilt 1966 · S/N 28-22245 N8368WIronwing Aviation Group LLC · San Diego, CABuilt 1965 · S/N 28-2565 N83694Heatwole Oren E · Dayton, VABuilt 1981 · S/N 32R-8113060 N8369ANorthern Ventures II LLC · Carl Junction, MOS/N 28-8116198 N8369RWolfgang Aviation LLC · Lynnwood, WABuilt 1966 · S/N 28-22246 N8369WDunagan Jimmy Miles Jr · Trenton, TNBuilt 1965 · S/N 28-2566 N8369XTemesvary Peter · Katy, TXBuilt 1981 · S/N 28-8190211 N8369YLand Sea Air LLC · West Tisbury, MAS/N 28-8190212 N8369ZB & J 58 Inc · Fredericksburg, VABuilt 1981 · S/N 28-8190213 N836FSSmart01 LLC · Kissimmee, FLBuilt 1981 · S/N 28-8116200 N8370AIlich Randy Trustee · Ione, CABuilt 1981 · S/N 32R-8129059 N8370CFigueroa Daniel · Dorchester, MABuilt 1975 · S/N 28-7625107 N8370RYandik Stephen E Jr · Hudson, NYBuilt 1966 · S/N 28-22247

Back to AD 87-08-08 R3