Skip to content

Registered aircraft · 25,370

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-25-07-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-25-07-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-25-07-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-25-07-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-25-07-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-25-07-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.

N5304EDornink Farms LLC · Freeport, ILS/N 17271830 N5304FHurt J William · Hachita, NMBuilt 1979 · S/N 17273131 N5304SWindward Air LLC · Janesville, WIS/N R18201539 N53053Taylor Jesse L · Venus, FLBuilt 1978 · S/N 177RG1332 N53054Ott Robert · Medina, OHBuilt 1981 · S/N 17274674 N5305KJ M F And Associates Inc · Alexandria, VABuilt 1980 · S/N 17274055 N5305VAmerican Academy Of Aeronautics Inc · Stanford, CAS/N 172RG0504 N53061Flying Ducks Aviation LLC · Newport, ORBuilt 1978 · S/N 177RG1334 N53065Cherry Hill Aviation LLC · Freetown, INBuilt 1981 · S/N 17274676 N53069Northwoods Air LLC · Orono, MEBuilt 1981 · S/N 17274678 N5306EN5306e LLC · Ashburn, VABuilt 1978 · S/N 17271832 N5306KMills Bradley W · Wichita Falls, TXBuilt 1980 · S/N 17274056 N5306RSheldon Scott H · Cohasset, MABuilt 1979 · S/N 172RG0051 N53073Zahnow Todd · Raub, NDBuilt 1978 · S/N 177RG1337 N53077Megasky Holdings LLC · Charleston, SCBuilt 1981 · S/N 17274679 N53080Isaacs Christopher W · Advance, NCBuilt 1978 · S/N 177RG1340 N53087Colorado North Western Community College · Rangely, COBuilt 1981 · S/N 17274681 N53088Sangal Shiddhartha · Annandale, NJBuilt 1978 · S/N 177RG1343 N5309JRegistered aircraftRegistration pending, pending cancellationS/N 17273759 N530CACavalair LLC · San Francisco, CABuilt 1977 · S/N 152-79757 N530HSCti Aircraft Leasing LLC · Memphis, TNBuilt 2014 · S/N 1205 N530TACaprock Dairy LLC · Muleshoe, TXS/N R18201259 N530WBDmb Aircraft Inc · Wilmington, DEBuilt 1975 · S/N 17265399 N53103Top Flight Aerial Photography LLC · Georgetown, TXBuilt 1978 · S/N 177RG1347 N53105Pence Dale E · Garnett, KSBuilt 1974 · S/N 18801625T N53107Pea-Wayman Flight LLC · Daytona Beach, FLS/N 17274684 N53108Prindle Steven G · Seaford, DEBuilt 1978 · S/N 177RG1348 N5310DD & S Aviation LLC · Spring, TXBuilt 1979 · S/N 17272508 N5310H426th Aero Squadron LLC · Cropwell, ALBuilt 1979 · S/N 15284084 N5311SGagliardi Richard M Trustee · Mill Spring, NCBuilt 1980 · S/N R18201543 N5312HSkywarrior Flight Training Inc · Pensacola, FLBuilt 1975 · S/N 17265400 N5312MMoore Aviation Inc · Beaver Falls, PABuilt 1980 · S/N 15284526 N5312QHoogendorn Homer E · Wasilla, AKBuilt 1981 · S/N 15285098 N53134Sundog Logistics LLC · Lenexa, KSBuilt 1981 · S/N 17274691 N5313USky Quest 210 LLC · Clarksdale, MSBuilt 1984 · S/N 21064862 N53147Cloud Cappers Flying Club Inc · Salisbury, NCBuilt 1981 · S/N 17274693 N5314E57d Flyers LLC · Shelby Township, MIBuilt 1978 · S/N 17271835 N5314KLaporte Aviation Services Inc · La Porte, INBuilt 1980 · S/N 17274060 N5314MAlpha Golf Aviation LLC · Naples, FLBuilt 1980 · S/N 15284528 N53152Griffin Bruce H · Trenton, FLBuilt 1978 · S/N 177RG1352 N53158Schoen William R · Madison, CTS/N 177RG1353 N53160Benson Michael H · New Castle, PABuilt 1978 · S/N 177RG1354 N5316RTraining Planes LLC · Tampa, FLBuilt 1979 · S/N 172RG0053 N5316SDk Air LLC · Brookings, ORBuilt 1980 · S/N R18201545 N53175Kendall Investment Corp · Three Lakes, WIFirst renewal noticeS/N 177RG1357 N5317ABlue Skies Air LLC · Allen, TXBuilt 1979 · S/N 21063365 N5317DMonroe City Aviators LLC · Palmyra, MOBuilt 1979 · S/N 17272513 N5317HHottel Cessna LLC · Prescott, AZBuilt 1975 · S/N 17265401 N5317KN5317k Corp Trustee · Wilmington, DEBuilt 1980 · S/N 17274061 N5317TCovert Charles F · The Dalles, ORBuilt 1982 · S/N R18201856

Back to AD 80-25-07 R1