Registered aircraft · 40,472

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.

N2903LSchillinger Bradley Charles · Honeoye Falls, NYBuilt 1967 · S/N 670066 N2903XBrowning Mcpherson Aviation LLC · Auburn, KYBuilt 1967 · S/N 17700303 N29047State College Pilots Club · Philipsburg, PABuilt 1974 · S/N 17264096 N29049Weiman Magnus · Lynchburg, VABuilt 1979 · S/N 28-7990429 N2904MLange Keith J · Wasilla, AKBuilt 1946 · S/N 12-1318 N29056Land Of Lakes Aviation LLC · Eagle River, WIBuilt 1974 · S/N 17264097 N2905ECappadona Roy · Iliamna, AKBuilt 1978 · S/N 17271369 N2905PSimpson Danny R · Waunakee, WIBuilt 1955 · S/N 22-3172 N2905XRudy Schmitt · Brookshire, TXBuilt 1967 · S/N 17700305 N2905ZWmh Aviation LLC · Buckley, WABuilt 1978 · S/N 358-78 N2906LHogue Aviation LLC · Dover, PABuilt 1967 · S/N 670300 N2906MFry Steven G · Eagle River, AKBuilt 1946 · S/N 12-1321 N29076Flight Dynamics LLC · De Leon Springs, FLBuilt 1987 · S/N 1022 N2907PWickenheiser John D · Newport, MIBuilt 1955 · S/N 22-3175 N2908GGraves Sam · Tarkio, MOBuilt 1959 · S/N 263 N2908PHull Mahlon B · Sedro Woolley, WABuilt 1955 · S/N 22-3176 N2908UBarrett H Gould · Myrtle Beach, SCS/N 1023 N29098Gill Stuart W Jr · Kingsport, TNBuilt 1979 · S/N 28-7990436 N2909QHelman Tom · Evanston, WYBuilt 1979 · S/N 28-7916533 N290AMWheaton Megan E · Orchard Park, NYS/N 2096 N290HADon'T Call Me Shirley LLC · Fort Myers, FLBuilt 1966 · S/N 28-3624 N290KCTsunami Skydivers Inc · Las Vegas, NVBuilt 1990 · S/N 1301 N290NDChristiansen Aviation LLC · Wilmington, DEBuilt 1998 · S/N 4496021 N290VGAlmy David W · Riverside, CAS/N 23-5 N29107Wrong Brothers Aviation LLC · Brighton, MIBuilt 1974 · S/N 17264100 N2910XTallman Richard E · Lykens, PABuilt 1967 · S/N 17700310 N2911Dewinter Thomas A · Waunakee, WIBuilt 1968 · S/N 86 N2911GOrtega Rolando J · Sanford, FLBuilt 1979 · S/N 28-7916537 N2911XRobbins Donald V · Anchorage, AKBuilt 1967 · S/N 17700311 N2912MHarriman Aviation LLC · Pearland, TXBuilt 1977 · S/N 28-7890279 N2912PJackson Robert S · Gallatin, TNBuilt 1955 · S/N 22-3180 N2912XAmbler Carlos S · Mendota, ILBuilt 1987 · S/N 1025 N2912ZFord Charles D · Clifton, TNBuilt 1959 · S/N 22-6882 N29131Kelly Alex · Arlington, VTBuilt 1987 · S/N 1027 N2913ATruesdell Shannon · Stephenville, TXBuilt 1988 · S/N 1062 N2913EG & M Aircraft Inc · Wheat Ridge, COBuilt 1978 · S/N 17271371 N2913UAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1981 · S/N 44-8107057 N2914AAvier LLC · Beverly, MABuilt 1979 · S/N 28-7916538 N2914BWhite And Blue Wings LLC · Oakland Park, FLBuilt 1979 · S/N 28-7916539 N2914GSchubert Matthew · Belleair Beach, FLBuilt 1979 · S/N 28-7990551 N2914MPannone Steven R · Palmer, AKBuilt 1947 · S/N 12-1334 N2914PPerreault Guy · Newbury Park, CABuilt 1955 · S/N 22-3182 N2914QEast High Flying · Othello, WABuilt 1987 · S/N 1028 N2914ZEarle Russell John · Reno, NVBuilt 1959 · S/N 22-6884 N29159Southridge Developments Inc · San Miguel, CAFirst renewal noticeBuilt 1974 · S/N 17264103 N29160Felber Dave A · Florissant, MOBuilt 1974 · S/N 17264104 N29168Galer Michael J Jr · Lockwood, MOBuilt 1974 · S/N 17264105 N2916WPilots Flying School LLC · Manalapan, NJBuilt 1979 · S/N 44-7995300 N2917PRegistered aircraftBuilt 1955 · S/N 22-3185 N2917ZRegistration Pending · Granby, MORegistration pendingBuilt 1959 · S/N 22-6887

Back to AD 80-04-03 R2