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.

N2434MSky'S The Limit Flying Club Inc · Findlay, OHBuilt 1977 · S/N 28-7890251 N2435MBrolan Aviation LLC · Kansas City, MOBuilt 1977 · S/N 28-7890253 N2435PGarst William P · Johnson City, TNBuilt 1955 · S/N 22-2806 N2436YAlpha Flight Academy · Concord, CANon-citizen corporation, flight hours not reportedBuilt 1985 · S/N 28-8516056 N24372Curns James R · New London, WIBuilt 1970 · S/N 28-5665 N2438ERainier Flight Service LLC · Renton, WABuilt 2000 · S/N 17280878 N2438PDavey Kenneth E · Lake Crystal, MNBuilt 1955 · S/N 22-2809 N2438RSpeed Hunter Aviation LLC · Franklin, OHBuilt 1969 · S/N 28-5622 N2439PNeal Christopher C · Staples, MNBuilt 1955 · S/N 22-2810 N243AKHilwig Kara · Wasilla, AKBuilt 1989 · S/N 1809010 N243CMRegistered aircraftS/N 545E N243CYHarvey Steven T · Honolulu, HIBuilt 2000 · S/N 2081 N243EHVeracity Aviation LLC · Seguin, TXS/N 3482 N243MAJ W Peterson Inc · Warren, MNBuilt 2003 · S/N 479-2003 N243SWWells Paul L · Whitefish, MTFirst renewal noticeBuilt 1999 · S/N 001SW N243WMoore William · Dalhart, TXBuilt 1971 · S/N 17260205 N243XWilliamson Lee E · Franklin, KYS/N 160 N2442EExecutive Flyers Inc · Sacramento, CABuilt 1978 · S/N 17271285 N2444JDavis Bret R · Boynton Beach, FLBuilt 1979 · S/N 18-7909124 N2444PMcgowan Robert A · Burgaw, NCS/N 22-2815 N24450Haley David A · Whitethorn, CABuilt 2004 · S/N 001 N2445PBolivar Flyers Inc · Brighton, MOBuilt 1955 · S/N 22-2816 N2446VLipscomb Rik · Wichita Falls, TXFirst renewal noticeBuilt 1983 · S/N 14795330 N2447ADyer Clifton R · Richland, WABuilt 2004 · S/N 70966 N2447RGift Academy Inc · Vernon, TXBuilt 1969 · S/N 28-5623 N2448EPwc Engine Air Inc · Manorville, NYS/N 17271288 N2448PHopkins Andrew J · Pickett, WIS/N 001 N2448RRegistration Pending · Highland Lakes, NJRegistration pendingS/N 28-5624 N2449EWikette Mathias · West Chester, OHBuilt 1970 · S/N 28-26801 N2449PSchulze Thomas A · Bloomville, OHBuilt 1955 · S/N 22-2821 N244AKRuckman Jim D Jr · Clarksville, TNBuilt 1982 · S/N 18-8209016 N244ATAirline Transport Professionals Corp Of USA · Wilmington, DEBuilt 2001 · S/N 4496043 N244BJJapundza Bob · Kokomo, INBuilt 2000 · S/N 22977 N244BMCape Fear Aviation Maintenance LLC · Fayetteville, NCBuilt 1974 · S/N 28-7415157 N244CZBradley Tyson A · Abilene, TXBuilt 2000 · S/N 0244 N244DAPrairie Winds Aviation LLC · Overland Park, KSBuilt 1972 · S/N 17261294 N244DRG H Enterprises Inc · Baton Rouge, LABuilt 1972 · S/N 28-7305018 N244DWInternational Air Services Inc Trustee · Carson City, NVBuilt 2002 · S/N 0001 N244ERKeith Bryan P · Los Angeles, CABuilt 1992 · S/N 10123 N244FRSmith Larry · Ulysses, KSBuilt 1978 · S/N 17270490 N244NDPlane Nonsense Inc · Middletown, DEBuilt 1999 · S/N 2842054 N244RVSalcedo Daniel Richard · Fort Lauderdale, FLS/N 1242 N244SDPerazzo Enterprises Inc · Brookeland, TXS/N 28-7125536 N244STAskew Stell B III · Durham, NCBuilt 1976 · S/N AA5A-0138 N244WHLegoubin Philip · Broomfield, COS/N HUG-001 N2450PMerit Aviation LLC · Fort Myers Beach, FLBuilt 1955 · S/N 22-2823 N2450UDouble D Flyboys LLC · Taylorsville, UTBuilt 1979 · S/N 28-8090046 N2451ROracle Aviation LLC · Omaha, NEBuilt 1970 · S/N 28-5754 N2452PStichter Darin J · Wedderburn, ORFirst renewal noticeBuilt 1955 · S/N 22-2825 N2452UPuryear Rodney K · Pampa, TXBuilt 1982 · S/N 172RG1049

Back to AD 80-04-03 R2