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.

N5171USummers Jeffrey L · Pekin, INBuilt 1980 · S/N 172RG0272 N5171WPeters W Benny · Garden City, KSS/N 28-202 N5172HMsi Fuel Management Inc · Vacaville, CABuilt 1975 · S/N 17265359 N5173LDevries Pat DBA · Germansville, PABuilt 1967 · S/N 28-3994 N5173PColorado Aviation Group LLC · Colorado Springs, COS/N 24-192 N5173SDamore Joseph · Ingleside, ILBuilt 1970 · S/N 28-7105027 N51748Planenutz LLC · Deland, FLBuilt 1980 · S/N 17274342 N5174AWells Lavar W · Hanksville, UTBuilt 1956 · S/N 28174 N5174EBlue Sky Pilots Inc · Salem, ORBuilt 1978 · S/N 17271752 N5174HFlying Finn Enterprises LLC · Wilmington, DEBuilt 1975 · S/N 17265360 N5174LVentura Robert E · Ventura, CAS/N 28-4459 N5174SKatzakian Trevor T · Lodi, CABuilt 1970 · S/N 28-7105028 N5175EWinston Jacob · Granbury, TXBuilt 1978 · S/N 17271753 N5175SBlu Skye Distribution Inc · Mount Holly, NCBuilt 1970 · S/N 28-7105029 N5175TMcclain Timothy J · Tucson, AZBuilt 1966 · S/N 147 N5176HBoyer Christopher A · Anchorage, AKBuilt 1948 · S/N 14-196 N5176LMilliner Greg A · Kokomo, INBuilt 1967 · S/N 28-4462 N5176RRight Rudder Flight Training LLC · La Verne, CABuilt 1979 · S/N 172RG0044 N5176SNora Jet LLC · Granbury, TXS/N 28-7105030 N5176TScott Judson M · Wasilla, AKBuilt 1967 · S/N 153 N5176VVangorder Donna · Greenwood, ARS/N 172RG0459 N5177FPray Aviation Inc · Augusta, KSBuilt 1976 · S/N 28-7715096 N5177HPomeroy Cattle Ranch LLC · Kalispell, MTBuilt 1975 · S/N 17265361 N5177PLi Steven Y · Warren, NJBuilt 1958 · S/N 24-197 N5177WBuffham Daniel L · Meridian, IDBuilt 1961 · S/N 28-212 N5178AHale Mitchell D · Chugiak, AKBuilt 1962 · S/N 18-7483 N5178HGage Scott M · Anchorage, AKS/N 14-200 N5178LMinick And Son LLC · Beatrice, NEBuilt 1967 · S/N 28-4464 N5178RHampton Flying Services LLC · Portsmouth, NHBuilt 1974 · S/N 17263395 N5178WMahoney Christopher P · Quakertown, PABuilt 1961 · S/N 28-213 N51793Lindsey Richard A · Richmond, TXBuilt 1980 · S/N 17274347 N5179HFlight Time Builders Inc · Memphis, TNBuilt 1975 · S/N 17265362 N5179PHangar 17 LLC · Sheridan, WYBuilt 1958 · S/N 24-199 N5179VFairmont State University · Fairmont, WVBuilt 1980 · S/N 172RG0460 N517DLDelta Leema Aviation LLC · Moncks Corner, SCBuilt 1977 · S/N 17268965 N517GSPtag Flight Service LLC · Vidalia, GABuilt 1996 · S/N 2996 N517JGollus Daniel T · Lockport, NYBuilt 1997 · S/N 22753 N517JCProfessional Pilot Services · Appleton, WIBuilt 1971 · S/N 28-7125098 N517JPJones Jerry K · Syracuse, UTBuilt 2007 · S/N 001 N517LBuchenroth Steven L · Huntsville, OHFirst renewal noticeBuilt 1969 · S/N BP1 N517RSGraham Konner T · Pittsburg, TXBuilt 1998 · S/N 21117 N517SMMcelvain Pete R · Iowa Park, TXBuilt 1968 · S/N 17257318 N517WCFreedom Wings LLC · Parker, COBuilt 1993 · S/N 1809065 N5180LGrogan Timothy · Bradenton, FLBuilt 1967 · S/N 28-4466 N5180RMacdonald Kaitlyn · Dillon, MTS/N 17263397 N5181HRegistered aircraftBuilt 1975 · S/N 17265363 N5181REdelen Daniel R · Clayton, NCBuilt 1974 · S/N 17263398 N5181SHicks Douglas A · Cumming, GABuilt 1970 · S/N 28-7105035 N5181WSzymanski Janet M · Alanson, MIBuilt 1961 · S/N 28-216 N5182ERegistered aircraftBuilt 1978 · S/N 17271756

Back to AD 80-04-03 R2