Skip to content

Registered aircraft · 1,267

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-26-04-R1') 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-26-04-R1') 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-26-04-R1')
    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-26-04-R1')
  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-26-04-R1')
  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-26-04-R1')
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.

N6715APacific Fleet Aviation LLC · Rochester, NYS/N 27-7954082 N6716YGot Wings LLC · Woodbury, NYBuilt 1968 · S/N 27-4046 N6730YUrubek Raymond L · Refugio, TXS/N 27-4062 N6739YTropical Interisland Express Corp · Doral, FLBuilt 1968 · S/N 27-4073 N6751YLarson Kris K · Fullerton, CAFirst renewal noticeBuilt 1968 · S/N 27-4079 N6754YNovember Nine One Four Eight Juliet LLC · Fulton, MOBuilt 1968 · S/N 27-4083 N6760AFreestone William W · Saint Augustine, FLS/N 27-7954086 N6768YPiper Aircraft Inc · Vero Beach, FLBuilt 1968 · S/N 27-4100 N6776APacific Fleet Aviation LLC · Rochester, NYBuilt 1979 · S/N 27-7954088 N6777YPlaquemines Parish Government · Belle Chasse, LABuilt 1968 · S/N 27-4109 N6786YMuhlenkort Mary Anna · Beresford, SDBuilt 1968 · S/N 27-4122 N6787YCoachron Investments · Grosse Ile, MIBuilt 1969 · S/N 27-4124 N6793YPiper Aircraft Inc · Vero Beach, FLBuilt 1969 · S/N 27-4131 N6809YPiper Aircraft Inc · Vero Beach, FLBuilt 1969 · S/N 27-4147 N680KTalos Aviation Group LLC · Blackstone, VABuilt 1968 · S/N 27-3892 N6810YAtem LLC · Helena, ALBuilt 1969 · S/N 27-4148 N6814YHartwig Acft Fuel Cell Repair Ltd · Hallock, MNBuilt 1969 · S/N 27-4153 N6817YInternational Air Services Inc Trustee · Carson City, NVS/N 27-4156 N6823YWingsleasing LLC · Wichita, KSBuilt 1969 · S/N 27-4163 N6825YDenton J Frederick · Hutchinson Island, FLS/N 27-4165 N6836YOld School Aircraft LLC · Jackson, TNBuilt 1969 · S/N 27-4176 N6843YBarlam Theodore P · Poway, CABuilt 1969 · S/N 27-4187 N6854YChagres Flight Training LLC · Albuquerque, NMBuilt 1969 · S/N 27-4198 N6856YAviation Data LLC · Carson City, NVBuilt 1969 · S/N 27-4200 N6857YGraves Jessica M · Anthony, KSBuilt 1969 · S/N 27-4202 N685MDAbacus Automation Inc · Bennington, VTBuilt 1969 · S/N 27-4295 N6863YDempsey Donald B · Deland, FLBuilt 1969 · S/N 27-4208 N6865YDelaware Aircraft Trust LLC Trustee · New Castle, DEBuilt 1969 · S/N 27-4210 N6868AFlamingo Air Inc · Cincinnati, OHBuilt 1965 · S/N 27-3096 N6875YDodge Stanley R · Pocatello, IDBuilt 1969 · S/N 27-4222 N6879AScruggs Ken R · Plain City, OHS/N 27-7954104 N6880YLavalley Richard G Jr Trustee · Sylvania, OHBuilt 1969 · S/N 27-4228 N6882YFlamingo Air Inc · Cincinnati, OHS/N 27-4231 N6888YFlying W Leasing Inc · Bartlett, ILBuilt 1969 · S/N 27-4240 N6897YReabe Design LLC · De Pere, WIBuilt 1969 · S/N 27-4250 N68MWCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 1975 · S/N 27-7554126 N68SEGateway Flight Center LLC · Port Lavaca, TXS/N 27-3780 N68VEK F Aviation Inc · San Juan, PRBuilt 1970 · S/N 27-4457 N6902YJ L Darr & Son Inc · High Point, NCBuilt 1969 · S/N 27-4256 N6904ALesser Antilles Corp Trustee · Wilmington, DEBuilt 1979 · S/N 27-7954076 N6904YUnited Jet Sales Inc · Newark, DEBuilt 1969 · S/N 27-4259 N690BLincwings Society LLC · Austin, TXBuilt 1955 · S/N 23-382 N690RGRegistration Pending · Gurabo, PRRegistration pendingBuilt 1969 · S/N 274260 N6911YDelaware Aircraft Trust LLC Trustee · New Castle, DEBuilt 1969 · S/N 27-4266 N6913ANorthwoods Air LLC · Orono, MEBuilt 1979 · S/N 27-7954108 N6916YDk1 Aviation LLC · Fayetteville, NCBuilt 1969 · S/N 27-4272 N6917APiper Aircraft Inc · Vero Beach, FLBuilt 1979 · S/N 27-7954111 N6918DTucker Christopher W · Johnstown, COBuilt 1962 · S/N 23-2038 N6943AOber John A · Candor, NYBuilt 1979 · S/N 27-7954117 N6943YAce Tomato Co LLC · Daytona Beach, FLBuilt 1969 · S/N 27-4350

Back to AD 80-26-04 R1