Registered aircraft · 40,473

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.

N5272AWelch Kevin R · Hartland, WIBuilt 1961 · S/N 23-2019 N5272RRichmond Pilots Corp · Linden, NJBuilt 1974 · S/N 17263486 N5273LMancuso Dale · Dallas, TXFirst renewal noticeBuilt 1967 · S/N 28-4571 N5273RClear Prop Aviation LLC · Sterling, VABuilt 1974 · S/N 17263487 N5273SCarnegie Nursing Home Inc · Carnegie, OKBuilt 1971 · S/N 28-7125209 N52747Unicorn Papa Air LLC · Longwood, FLBuilt 1981 · S/N 17274598 N52749Middle Tennessee State University · Murfreesboro, TNS/N 17274599 N5274HLincoln Skyways Inc · Lincoln, CABuilt 1975 · S/N 17265392 N5274LRetzer Daniel R · Rockford, ILBuilt 1967 · S/N 28-4573 N52750Wieneke Robert A · Rockwall, TXBuilt 1981 · S/N 17274600 N5276LHaynie Sidney S · Sedona, AZBuilt 1968 · S/N 28-4575 N5276WThird Step 2 LLC · Wilmington, DEFirst renewal noticeBuilt 1962 · S/N 28-323 N5277SFers Mitchell A · Stafford Springs, CTBuilt 1970 · S/N 28-26908 N5277WPerkins Nathan Zachery · Bonanza, ORBuilt 1962 · S/N 28-325 N52789Alameda Aero Club · Alameda, CABuilt 1981 · S/N 17274607 N5278DN5278d LLC · Dover, DEBuilt 1979 · S/N 17272488 N5278RHussain Mahmoud Taimour Said · Miami, FLBuilt 1974 · S/N 17263492 N5278SN5278s LLC · Katy, TXBuilt 1970 · S/N 28-26911 N5278WJohns Tyler B · Folsom, CABuilt 1962 · S/N 28-326 N5279DDay Aviation Inc · Wilmington, DEBuilt 1979 · S/N 17272489 N5279GArnold Jason Mcree · Watkinsville, GABuilt 1979 · S/N 17273558 N5279LCarverair LLC · Lakeland, FLBuilt 1967 · S/N 28-4578 N5279MTownsend Tod N · White Sulphur Spgs, MTBuilt 1949 · S/N 18-119 N5279TDicecco Jennifer · West Chester, PABuilt 1972 · S/N 28-7225386 N5279WAmerican Aviator LLC · Arlington, TXBuilt 1962 · S/N 28-328 N527AWSkyhawk Td LLC · Siloam Springs, ARBuilt 1988 · S/N 1455 N527BCYager Greg J · Columbia Falls, MTBuilt 2005 · S/N 22465 N527BKShires Patrick O · San Andreas, CABuilt 1978 · S/N 28-7890310 N527CGGibbs Tyler · Gilbert, AZS/N 686 N527FLPatterson Roy A · Cameron, TXS/N 28-7125354 N527LMacan Ed · Overland Park, KSBuilt 1975 · S/N 28-7505228 N527SPRose Arthur K · Florence, ALBuilt 1991 · S/N 849 N527VMBradley Christopher · Orange, TXBuilt 2002 · S/N 11337 N52806Skywarrior Flight Training Inc · Pensacola, FLBuilt 1981 · S/N 17274610 N5280EStreeter Byrand DBA · Newcastle, WYBuilt 1978 · S/N 17271810 N5280MN5280m LLC · Elizabeth, COBuilt 1979 · S/N 17273671 N5280UStrantz Roger J · Denton, TXBuilt 1980 · S/N 172RG0320 N5280WKinney Colton S · Montrose, MNBuilt 1962 · S/N 28-329 N52815S & S Aircraft Inc · Bennington, VTBuilt 1981 · S/N 17274612 N52818Aeroluxe Aviation LLC · Nashville, TNBuilt 1981 · S/N 17274615 N5281JHowell Jason · Newaygo, MIBuilt 1980 · S/N 17273753 N5281LPioneer Aviation Inc · Fond Du Lac, WIBuilt 1968 · S/N 28-4581 N5281SKurkjian Daniel C · Chester Springs, PABuilt 1970 · S/N 28-26918 N5281WThomaston Mitchell E · Hampton, GABuilt 1962 · S/N 28-330 N5282KBaer Monte Wayne · Ronan, MTS/N 17274042 N5282LHodges Richard T · Williamston, MIBuilt 1967 · S/N 28-4582 N5282WFloe Glen M · Wickenburg, AZBuilt 1962 · S/N 28-331 N52837Registration Pending · West Warwick, RIRegistration pendingBuilt 1981 · S/N 17274617 N5283EYummy Apple LLC · Mesa, AZBuilt 1978 · S/N 17271812 N5283JMarianas Air Transfer Inc · Tinian, MPBuilt 1980 · S/N 17273754

Back to AD 80-04-03 R2