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.

N4560YCleveland William B III · Canal Fulton, OHBuilt 1973 · S/N 18-7309017 N4561XAir Bhnb LLC · Statesboro, GAS/N 28-7625055 N4562RMcclure Richard A · Victoria, TXS/N 28-21304 N4562TSellers Kelly A · Crossville, TNS/N 28-7205186 N4565AGriswold Joshua M · Wasilla, AKBuilt 1956 · S/N 22-3876 N4565FHughey Charles A Jr · Oak Ridge, TNBuilt 1976 · S/N 28-7725022 N4565RHenderson Javier · Raleigh, NCS/N 28-21308 N4566RMedia Stew LLC · Carson City, NVBuilt 1965 · S/N 28-21309 N4567ADonovan Timothy P · Wichita Falls, TXBuilt 1956 · S/N 22-3878 N4568ABartlett Michael W · Barron, WIBuilt 1956 · S/N 22-3879 N4568RChuss Edward J · Metamora, MIBuilt 1965 · S/N 28-21326 N4569RNoco Flying Club LLC · Fort Collins, COBuilt 1966 · S/N 28-21310 N4569XSequoias David O · Waxhaw, NCBuilt 1975 · S/N 287625057 N456AMKrause Kade G · Jackson, MTBuilt 1998 · S/N 1412 N456CBCollins Bruce H · Caldwell, TXBuilt 1968 · S/N 17257257 N456DSlesser Carl J · Crestwood, KYBuilt 1993 · S/N 21569 N456DPBorder Zachary J · Molalla, ORBuilt 1991 · S/N 365 N456HUCornelius Wayne · Mount Arlington, NJBuilt 1998 · S/N 1436 N456LLemma Joseph M · Parker, COBuilt 1962 · S/N 28-863 N456MDMyres Mark D · Freeland, WABuilt 1996 · S/N 20107 N456PBAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1997 · S/N 400-97 N456PMBerry Michael G · Hot Springs, ARBuilt 1966 · S/N 28-22354 N456RBSammons Michael A · Lubbock, TXS/N 654 N456RHMalik Todd S · Matthews, NCBuilt 1979 · S/N AA5B1252 N456RJGraae Michael Horace · Los Angeles, CABuilt 1995 · S/N 21701 N456THB R S Leasing Inc · Wilmington, DEBuilt 1980 · S/N ME-319 N456WMWright Alfred M · Toney, ALBuilt 2001 · S/N 001 N456YDodson International Parts Inc · Rantoul, KSBuilt 2000 · S/N 2843353 N4571WBernard Scott Sr · Denham Springs, LAS/N 13061 N4571XFly Boys Aviation LLC · Tecumseh, MIS/N 28-7690039 N4572WKelton Joel B · May, TXBuilt 1976 · S/N 13062 N4573RKaufmann Carl S · Springfield, MABuilt 1965 · S/N 28-21314 N4574RKing Vincent A · Grand Junction, COBuilt 1965 · S/N 28-21316 N4575FSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1976 · S/N 28-7715049 N4575XPar Mar Bluffs LLC · Parker, SDS/N 28-7690034 N4576FDakota Aviation LLC · Sioux Falls, SDBuilt 1976 · S/N 28-7715050 N4578WAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1976 · S/N 13068 N4579JSnagwood Corp · Brentwood, CABuilt 2012 · S/N 5819 N4579RSmelser Brady W · Glendive, MTBuilt 1965 · S/N 28-21321 N457ACBrown David R · Niceville, FLBuilt 1999 · S/N 414-99 N457BCMorris Thomas Z Trustee · Spokane Valley, WABuilt 1974 · S/N 17264589 N457CFHelliwell Anne · Sun City, CAS/N 08 N457DHRichardson Justin · Glasgow, KYBuilt 1998 · S/N 20457 N457RBHale Francis J III · Raleigh, NCBuilt 1990 · S/N 1457 N457SKWorld Marketing Syndicate I · Wilmington, DEBuilt 1975 · S/N 17264736 N457SPSouth Dakota State University · Brookings, SDBuilt 1999 · S/N 172S8321 N457TThompson Ernest W Jr · Yukon, OKBuilt 1976 · S/N 28-7690218 N4580FRegistered aircraftBuilt 1976 · S/N 28-7790045 N4580RMartin James E · Rostraver Township, PABuilt 1966 · S/N 28-21322 N4581XRegistered aircraftBuilt 1975 · S/N 28-7690042

Back to AD 80-04-03 R2