Registered aircraft · 54,017

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-20-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:87-20-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:87-20-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:87-20-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:87-20-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:87-20-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.

N5304EDornink Farms LLC · Freeport, ILS/N 17271830 N5304FHurt J William · Hachita, NMBuilt 1979 · S/N 17273131 N5304NHotrod Aviation LLC · Fayetteville, ARBuilt 1980 · S/N 18267634 N5304RSouthern Arkansas Univ Tech · Camden, ARFirst renewal noticeBuilt 1965 · S/N 17252826 N5304SWindward Air LLC · Janesville, WIS/N R18201539 N5304TR Gerald Hough III · Mount Morris, ILBuilt 1964 · S/N 17251204 N53053Taylor Jesse L · Venus, FLBuilt 1978 · S/N 177RG1332 N53054Ott Robert · Medina, OHBuilt 1981 · S/N 17274674 N53055Echo Lake Air LLC · Soldotna, AKBuilt 1974 · S/N 18502343 N53057Endsley Gregory C · Sterling, AKBuilt 1974 · S/N 18502345 N53059Smith Sidney R Trustee · Rllng Hls Est, CABuilt 1974 · S/N 18502347 N5305BHamlin Curtis G · North Pole, AKS/N 33305 N5305KJ M F And Associates Inc · Alexandria, VABuilt 1980 · S/N 17274055 N5305NBennett Brian · Horseheads, NYBuilt 1980 · S/N 18267635 N5305RWoodman Larry · Nottingham, NHBuilt 1965 · S/N 17252827 N5305SJohnson Brent C · Appleton, MNBuilt 1966 · S/N 337-0405 N5305TMccall Freddie W · Brewton, ALBuilt 1964 · S/N 17251205 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 N5307BHunter Warren M · Rainelle, WVBuilt 1956 · S/N 33307 N5307QSkyway Leasing Inc · Lakeland, FLBuilt 1972 · S/N 15073207 N5307RFabian Brian L · Corcoran, MNBuilt 1965 · S/N 17252829 N53080Isaacs Christopher W · Advance, NCBuilt 1978 · S/N 177RG1340 N53083Clearwater Potlatch Timber Protect · Orofino, IDBuilt 1974 · S/N 18502367 N53087Colorado North Western Community College · Rangely, COBuilt 1981 · S/N 17274681 N53088Sangal Shiddhartha · Annandale, NJBuilt 1978 · S/N 177RG1343 N5308QBig Sky Leasing LLC · Boise, IDBuilt 1972 · S/N 15073208 N5308TAvventura LLC · San Marcos, CAFirst renewal noticeBuilt 1964 · S/N 17251208 N53092Reilly Patrick M · Anchorage, AKBuilt 1974 · S/N 18502371 N5309BKadlubowski Michael J · Colorado Springs, COBuilt 1956 · S/N 33309 N5309DPotter John · Payson, UTS/N 50207 N5309JRegistered aircraftRegistration pending, pending cancellationS/N 17273759 N5309QSauvageau Daniel W · Roseville, CABuilt 1972 · S/N 15073209 N5309SEnd Poverty Now Inc · Maumee, OHS/N 337-0409 N530CACavalair LLC · San Francisco, CABuilt 1977 · S/N 152-79757 N530RCLoizides Louis N · Safety Harbor, FLBuilt 1963 · S/N 15060171 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

Back to AD 87-20-03 R2