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.

N62891Wings Over Texas Holdings LLC · Denton, TXS/N 17275352 N6289DYecny Enterprises Inc · San Luis Obispo, CABuilt 1979 · S/N 17272695 N6289FSbk Aviation LLC · Festus, MOBuilt 1979 · S/N 17273181 N6289URegistered aircraftBuilt 1962 · S/N 2128 N6289WCronk Howard · Council Bluffs, IABuilt 1964 · S/N 28-20233 N628APThomas Lucas G · Beebe, ARBuilt 1974 · S/N 17-74 N628ATPayne David P · Lamar, COBuilt 1996 · S/N 24407 N628AWHobart Aviation Inc · Akron, OHBuilt 1959 · S/N 23-1790 N628GRKrause Jason M · Glendale, AZBuilt 2000 · S/N 80745 N628JCDelaney Patrick James · Marion, TXBuilt 1974 · S/N 17262911 N628MKFarmer Peter E · Heber Springs, ARFirst renewal noticeBuilt 2001 · S/N 80845 N628RBBrown Michael C · Erie, KSBuilt 1972 · S/N 17260622 N628TCLayton James L · Carrollton, GABuilt 1995 · S/N 1212-95 N62901Bates Field Aero Club Inc · Mobile, ALBuilt 1981 · S/N 17275355 N6290UCarney James A · Dallas, TXFirst renewal noticeBuilt 1962 · S/N 2129 N6290VDelta Sierra Aviation LLC · White Salmon, WABuilt 1980 · S/N 172RG0610 N62918Neron II LLC · New Smyrna Beach, FLS/N 17275359 N6291TEmerald City Aircraft & Leasing Inc · Port Orchard, WABuilt 1994 · S/N 2410M N6291WBrenton Perry · Crestview, FLBuilt 1964 · S/N 28-20335 N6291ZBordelon Thomas D · Elephant Butte, NMBuilt 1960 · S/N 25-361 N6292RHynes Kevin P · Wichita Falls, TXBuilt 1979 · S/N 172RG0152 N6292UCherry Creek School District No 5 · Greenwood Village, COBuilt 1962 · S/N 2131 N6292WAmerican Aviator LLC · Arlington, TXBuilt 1964 · S/N 28-20336 N62938Two Guys Aviation LLC · Idaho Falls, IDBuilt 1981 · S/N 17275361 N6293GMindy Limited LLC · Muscatine, IABuilt 1979 · S/N 17273588 N6293JClear Horizon Holdings LLC · Cheyenne, WYBuilt 1976 · S/N 28-7690395 N6293UCairn Holdings LLC · Highlands Ranch, COBuilt 1962 · S/N 2132 N6293WFisher Russell D · Vacaville, CABuilt 1964 · S/N 28-20338 N62946Christiansen Aviation LLC · Wilmington, DEBuilt 1981 · S/N 17275365 N6294BAusten Tim · Oregon City, ORBuilt 1976 · S/N 91176 N6294CB A R C Asset Management LLC · Boynton Beach, FLBuilt 1978 · S/N 28-7890358 N6294RMitrenko Alexander V · Selinsgrove, PABuilt 1979 · S/N 172RG0154 N6294ULamontagne Brian D · Wyandotte, MIBuilt 1962 · S/N 2133 N62953Dodge Inc · Wilmington, DEBuilt 1981 · S/N 17275367 N6295DCandace A Larned Enterprises Inc · Long Beach, CABuilt 1979 · S/N 17272700 N6295URawareo LLC · Warsaw, MOS/N 2134 N6295WJ Delgado Aviation LLC · Tulsa, OKBuilt 1964 · S/N 28-20340 N62960Fossen Kenneth J · Omaha, NEBuilt 1981 · S/N 17275368 N62968Stanley Farms · Grygla, MNBuilt 1972 · S/N 373-72 N6296FCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1979 · S/N 17273185 N6296NBurg Clinton A · Creswell, ORBuilt 1957 · S/N 18-5696 N6296WBarthell Frederick · Sun City West, AZS/N 28-20341 N6297JYale Aviation Inc · New Haven, CTBuilt 1976 · S/N 28-7690394 N6297UBeasley Curtis L · Kennewick, WABuilt 1962 · S/N 2136 N6297WDevils Lake Aero Repair Inc · Devils Lake, NDBuilt 1964 · S/N 28-20342 N62982Peterson Derek R · Kenmare, NDBuilt 1972 · S/N 361-72 N62984Hopkins George · Chippewa Falls, WIBuilt 1972 · S/N 363-72 N6299DJav Air Services LLC · Anchorage, AKBuilt 1979 · S/N 17272704 N6299UKeelin Freddie B · Sagle, IDBuilt 1975 · S/N AA5-0782 N629AKCloward Marc D · Cordova, AKBuilt 1951 · S/N 18-122

Back to AD 80-04-03 R2