Registered aircraft · 40,471

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.

N8249NAero Club Aviation LLC · Apollo Beach, FLBuilt 1969 · S/N 28-25459 N8249WHartpence Damian K · Newcastle, OKBuilt 1965 · S/N 28-2397 N824DXElon Aviation LLC · Burlington, NCBuilt 1978 · S/N 28-7990061 N824GEaa Aviation Foundation Inc · Oshkosh, WIBuilt 1994 · S/N 01-P N824JTRenfro Jacqueline L · Bethel, AKBuilt 1957 · S/N 18-6040 N824PAHot Wings Aviation LLC · Indianapolis, INBuilt 2020 · S/N 2881336 N824PCHardee Jewell E · Keller, TXBuilt 2000 · S/N H-508DG N824PJDowney Joseph E · University City, MOBuilt 1976 · S/N M-1867 N824PKReisdorfer Mark J · La Follette, TNBuilt 2004 · S/N 81048 N824WSHampton Roads Charter Service · Chesapeake, VABuilt 2004 · S/N 3606 N82502Christofferson Kevin · Fruita, COBuilt 1977 · S/N 18-7709169 N82504Pentecost Benjamin I · Puyallup, WABuilt 1978 · S/N 18-7809181 N82505Kunkle Christopher · Santa Ynez, CABuilt 1978 · S/N 18-7809182 N82508Jones Matthew B · Wasilla, AKBuilt 1978 · S/N 18-7809183 N8250NBruce James E · Greenfield, INS/N 28-25460 N8250WMorehead Leonard E · Bryan, TXS/N 28-2399 N82518Zeafla Randall Reis · Elizabethtown, KYBuilt 1978 · S/N 18-7809184 N8251DSwenson Roger A · Pahrump, NVS/N TD-16 N8251NLarue Jesse W · College Station, TXBuilt 1969 · S/N 28-25461 N8251SAirlife Aviation LLC · Elkridge, MDS/N 28-8316081 N8251WKeddis Moheb N · Fairfax, VABuilt 1965 · S/N 28-2401 N82520Newman Scott W · Healdsburg, CABuilt 1977 · S/N 18-7709170 N8252CRoberts Dave C · Wibaux, MTBuilt 1954 · S/N 18-3677 N8252EMiami Flight Training LLC · Miami, FLBuilt 1980 · S/N 28-8016373 N8252NWhiting Reed Brandon · Mesa, AZBuilt 1969 · S/N 28-25462 N8252PMontgomery Daniel G · Wasilla, AKBuilt 1963 · S/N 18-8035 N8252ZHodges Albert H Executor · Lyons, GAS/N 28-8116011 N82530Flowers Christopher L · Anchorage, AKBuilt 1978 · S/N 18-7809187 N82544Cronquist Korey J · Wasilla, AKBuilt 1979 · S/N 18-7909001 N82547Jeffries Aviation LLC · Kalispell, MTS/N 18-7909003 N82549Airgo Incorporated · Centralia, ILS/N 44-8107015 N8254EPerfect Agreements Leasing · Trabucco Canyon, CABuilt 1980 · S/N 44-8107014 N8254FStewart Rodney W · Pensacola, FLBuilt 1977 · S/N 28-7715258 N8254JParis Air Inc · Vero Beach, FLBuilt 1982 · S/N 28-8216186 N8254NBlum William C · Alma, NEBuilt 1969 · S/N 28-25465 N82557Zehm Laura L · Monterey, CABuilt 1982 · S/N 28-8290161 N8255PKanooth Michael L · Washougal, WABuilt 1963 · S/N 24-3509 N8255WReed Emerson E · Winter Haven, FLBuilt 1965 · S/N 28-2406 N82563Registered aircraftBuilt 1977 · S/N 18-7709014 N82566Low James E · Fairbanks, AKBuilt 1978 · S/N 18-7909008 N8256EWilliams Evan H · Sebastopol, CABuilt 1980 · S/N 28-8116014 N8256PHouse Terry J · Mountain View, ARBuilt 1963 · S/N 24-3233 N8256VZ-Tech Research LLC · Greenville, TXBuilt 1980 · S/N 28-8116018 N8256WInland Northwest Flyers LLC · Spokane Vly, WAS/N 28-2407 N8256XSkyriders Inc · Pocatello, IDBuilt 1980 · S/N 28-8190016 N82577Sale Reported · Wasilla, AKSale reportedBuilt 1978 · S/N 18-7909009 N8257GDraco Flight School Inc · Chino, CABuilt 1982 · S/N 28-8290162 N8257JGruber Larry E · Delphi, INBuilt 1978 · S/N VAC-103-78 N8257WHou Barry · San Marino, CABuilt 1965 · S/N 28-2409 N8258JKenyon Travis · Phoenix, AZBuilt 1978 · S/N VAC-104-78

Back to AD 80-04-03 R2