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.

N5162REllis Harvey Airport Inc · Guthrie, OKBuilt 1974 · S/N 17263379 N5162SStramer Douglas W · Hazelton, NDBuilt 1970 · S/N 28-7105016 N5163DHaddix Stanley D · Hagerhill, KYBuilt 1979 · S/N 17272438 N5163LBowyer Richard A · Ormond Beach, FLS/N 28-4448 N5163PReynolds David A · Blacksburg, VAS/N 24-179 N5163SValley Fliers Flying Club · Auburn, WABuilt 1970 · S/N 28-7105017 N5163UValor View Aviation LLC · Midland, TXS/N 172RG0267 N5163WSeaton Ryan W · Savannah, TNBuilt 1961 · S/N 28-194 N5164EWilliams Kevin J · Giltner, NEBuilt 1978 · S/N 17271746 N5164PUpton John B · Lakeland, FLBuilt 1958 · S/N 24-180 N5164SNorthern Sky Aviation LLC · Harbor Springs, MIBuilt 1970 · S/N 28-7105018 N5164WMorning Aviation LLC · Altoona, PABuilt 1961 · S/N 28-195 N5165RAvocado Air LLC · Perkasie, PABuilt 1974 · S/N 17263382 N5165SVerte Chad W · Centralia, WABuilt 1970 · S/N 28-7105019 N5165WMetro Flyers LLC · Jackson, MSBuilt 1961 · S/N 28-196 N5166LEvans Jeffry · League City, TXBuilt 1967 · S/N 28-4451 N5166RCrown Flying Club · Overland Park, KSBuilt 1974 · S/N 17263383 N51670Colorado Northwestern Community College · Rangely, COBuilt 1980 · S/N 17274336 N51675Crawford Aviation Services LLC · Flagstaff, AZBuilt 1968 · S/N 18-8571 N5167EJkg LLC · Murfreesboro, TNBuilt 1978 · S/N 17271747 N5167HBest Joseph J · Coldwater, MIBuilt 1975 · S/N 17265357 N5167MTuggle Casey · Chattanooga, TNS/N M-2043 N5167SAngel Carl L · Pikeville, TNBuilt 1970 · S/N 28-7105021 N5167WThomas Bobby W Sr · Benson, NCBuilt 1961 · S/N 28-198 N51687Ambron Trevor L · Valdosta, GABuilt 1978 · S/N AA5B-0857 N5168HBenallo Joseph D · Homer, AKBuilt 1948 · S/N 14-179 N5168PCreegan John T Jr · Dundee, ILBuilt 1958 · S/N 24-185 N5168WRegistration Pending · Etowah, TNRegistration pendingBuilt 1961 · S/N 28-199 N5169LBishop Andre · Greenback, TNBuilt 1967 · S/N 28-4455 N5169PStockdale Alexander Ian · Los Banos, CAS/N 24-187 N5169SGoddard Julius W Jr · Perry, GABuilt 1970 · S/N 28-7105023 N5169VMalcolm Douglas · Shell Beach, CABuilt 1980 · S/N 172RG0458 N516AC39 Victor Aviation Inc · Macomb, ILBuilt 2000 · S/N 1294-2000 N516AVN388v LLC · Manassas, VABuilt 1981 · S/N 17275205 N516DDFawcett Walter L Jr · Wolfeboro, NHBuilt 1981 · S/N 18-8109010 N516JTMarcum Brad G · Universal City, TXBuilt 2002 · S/N 21479 N516JWAerostar LLC · Newport Beach, CABuilt 1975 · S/N 17265201 N516MSSouth Bay Aviation Inc · Torrance, CABuilt 1979 · S/N ME-166 N516PCSpace Coast Aircraft Co · Merritt Island, FLBuilt 2002 · S/N 2842150 N516PUAirplanes And Helicopters Of Oregon LLC · Sisters, ORBuilt 1983 · S/N 28-8316101 N516RVFoster Todd H · Long Beach, CABuilt 2003 · S/N 23393 N516SCThomason Scott D · Greer, SCBuilt 2001 · S/N 5098 N516TGNatchez Flight Training LLC · Natchez, MSBuilt 1977 · S/N 17268889 N51700Brown County Flying Club · Aberdeen, SDBuilt 1980 · S/N 17274338 N5170MWheeler David A · York, PABuilt 1978 · S/N M-2050 N5170PBosch Christopher J · Bloomington, MNBuilt 1958 · S/N 24-188 N5171HPan Air Flying Club · Miami, FLBuilt 1975 · S/N 17265358 N5171KBrewer Curtis E · Millington, TNBuilt 1980 · S/N 17273998 N5171LCrum Clarence F · West Salem, OHBuilt 1967 · S/N 28-4457 N5171RSamuels Jay M · East Tawas, MIBuilt 1974 · S/N 17263388

Back to AD 80-04-03 R2