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.

N6786After Hours Aviation LLC · Kalispell, MTBuilt 2003 · S/N 60295 N6786JHope John W · Greeneville, TNFirst renewal noticeBuilt 1968 · S/N 28-24514 N6786UCowboy Perspective LLC · Comanche, TXBuilt 1963 · S/N 172 N6787HGordon Caleb J · Waukesha, WIBuilt 1975 · S/N 17265582 N6787NN6787n LLC · Hanover, NHBuilt 1968 · S/N 680093 N6787TStar Aerobatics LLC · Columbia City, INBuilt 1976 · S/N AA5A0212 N6787WNewell Keith Douglas · Pahrump, NVBuilt 1965 · S/N 28-20917 N6788NSamples Kurtis K · Dallas, TXBuilt 1968 · S/N 690001 N6788PEast Cascades Aviation LLC · Powell Butte, ORBuilt 1960 · S/N 24-1792 N6788UHoughton Lawrence A · Rsm, CABuilt 1963 · S/N 174 N6789JBaase Robert F · Fairland, INBuilt 1968 · S/N 28-24517 N6789NOwnbey James L · Lubbock, TXBuilt 1968 · S/N 680094 N6789TCrosswind Aviation Of Oklahoma LLC · Stillwater, OKS/N 28-7916177 N678ACHabetz Kenneth B · Ragley, LABuilt 1998 · S/N 403-98 N678JWWhitacre John C · Brighton, IABuilt 1979 · S/N 28-7916266 N678PJShambora William E III · Athens, OHBuilt 1967 · S/N 28-4427 N678PMMills Donald · Independence, MOS/N 123 N6790UFischer Jody M · Fargo, NDBuilt 1963 · S/N 176 N6791BHassell Dan J · Ketchikan, AKBuilt 1956 · S/N 18-5025 N6791NHowarth Craig A · Stansbury Park, UTBuilt 1968 · S/N 680097 N6791UWarburton Frank W · Ware, MABuilt 1963 · S/N 177 N6791WCartagena-Cruz Joel · Avon Park, FLBuilt 1965 · S/N 28-20921 N6792BPeterson Joel · Fargo, NDBuilt 1956 · S/N 18-5026 N6792NWhite Rock Advisors · Wenham, MABuilt 1968 · S/N 680096 N6792ULancaster Bryce S · Plano, TXBuilt 1963 · S/N 178 N6792VSchmidt Jason A · Wasilla, AKBuilt 1970 · S/N 700085 N6793UBaynard Daryon Severino · Austin, TXBuilt 1963 · S/N 179 N6794EWalls Jerry L · Hawley, TXS/N 17272067 N6794HPs N6794h LLC · Green Bay, WIBuilt 1975 · S/N 17265583 N6794NHatcher David J · Papillion, NES/N 680098 N6795NStief Todd F · Mount Pleasant, SCBuilt 1968 · S/N 680098 N6795VTaub John F · Sarasota, FLBuilt 1970 · S/N 700086 N6796DMat-Su Air Service Inc · Willow, AKBuilt 1960 · S/N 5 N6796EBlain Kyra · Conroe, TXFirst renewal noticeBuilt 1978 · S/N 17272068 N6796HAmelia Reid Aviation LLC · San Jose, CABuilt 1975 · S/N 17265584 N6796JArcila Daniel · Lakeland, FLBuilt 1968 · S/N 28-24526 N6797EJoe Bob Nelson · Chickasha, OKBuilt 1978 · S/N 17272069 N6797NProav Services LLC · Northfield, MNBuilt 1968 · S/N 680099 N6797PBradley Jim · Waldorf, MDBuilt 1960 · S/N 24-1930 N6797UHeidenreich Peter · Monroe, GABuilt 1963 · S/N 2509 N6798DBeard Roger D · Mooresville, INBuilt 1959 · S/N 19 N6798HWnk Leasing LLC · Lewes, DEBuilt 1975 · S/N 17265586 N6798JDead Frog LLC · Miles City, MTBuilt 1968 · S/N 28-24529 N6798UAzevedo Robert S · Socorro, NMBuilt 1963 · S/N 2510 N6798WRich Lucas Aircraft Sales LLC · Lincoln Park, NJBuilt 1965 · S/N 28-20932 N6799URegistered aircraftBuilt 1963 · S/N 2511 N679CMShaughness Michael · Raleigh, NCBuilt 1990 · S/N 20102 N679DLBlink Squirrel Aviation LLC · Cherokee, IABuilt 1970 · S/N 17259138 N679HCKal Aire Flying Club Inc · Mattawan, MIBuilt 1979 · S/N 28-7990425 N679MMcquack Aviation LLC · Belding, MIS/N 2393

Back to AD 80-04-03 R2