Skip to content

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.

N33595N33595 Cherokee LLC · Austin, TXBuilt 1975 · S/N 28-7525211 N3359MWarren Wesley L · Coeur D Alene, IDBuilt 1947 · S/N 12-2216 N3359TDuquette Robert R · Elfrida, AZS/N 17700659 N3359ZKistler Stephen M Trustee · Monument, KSBuilt 1960 · S/N 22-7299 N335DPAdvanced Aviation Group LLC · Frederick, MDBuilt 1993 · S/N 2372 N335FDRoy Martin P · Chehalis, WABuilt 1989 · S/N 335 N335PABorek Thomas J · Homestead, FLBuilt 1979 · S/N 18-7909158 N335RLWeeks James S · Boynton Beach, FLBuilt 2002 · S/N 23254 N335RSYould Eric P Trustee · Palmer, AKBuilt 1977 · S/N 17268562 N335VHPremier Helicopters LLC · Carson City, NVBuilt 1994 · S/N 2464 N3360MStyer David · Pendleton, ORBuilt 1977 · S/N 28-7816339 N3360XCrail Aviation LLC · Colorado Springs, COBuilt 1966 · S/N 3373 N3361BSmith Marcus H · Roxboro, NCS/N 22-2166 N3361TPew Aaron · Mesa, AZS/N 17700661 N3362TMain Cynthia M · Richmond, TXFirst renewal noticeBuilt 1967 · S/N 17700662 N33636Murphy George E · Robinson, ILBuilt 1975 · S/N 28-7525213 N3363EMcfly LLC · Casper, WYBuilt 1978 · S/N 17271518 N3363MGlatt David · Bonita Springs, FLBuilt 1947 · S/N 12-2219 N3363PDubois Aviation Inc · Chino, CABuilt 1958 · S/N 23-1320 N33640Red Rooster Rentals LLC · Alto, GABuilt 1975 · S/N 28-7515349 N33641Sutton Aircraft Salvage LLC · Palmer, AKS/N 28-7505161 N33648Sadiq Ahmed · Ontario, CABuilt 1975 · S/N 28-7525219 N3364EPlsr LLC · Denton, TXBuilt 1978 · S/N 17271519 N3364THigh Mesa Aviation LLC · Naturita, COBuilt 1967 · S/N 17700664 N33655Gordon William S III · Aurora, COBuilt 1975 · S/N 28-7525220 N33659North Central Flight Center LLC · Warwick, RIBuilt 1975 · S/N 28-7515351 N3365BSmith James A · Lyle, WABuilt 1954 · S/N 22-2170 N3366Sutton Aircraft Salvage LLC · Palmer, AKS/N 23-1919 N33661Baker Justin Robert · Red Oak, TXBuilt 1975 · S/N 28-7505163 N33666Hancock Carl M · Glendale, AZBuilt 1975 · S/N 28-7505165 N33667Aptum Aviation Inc · Hicksville, NYBuilt 1975 · S/N 28-7505166 N33672Nulton Enterprises LLC · Johnstown, PABuilt 1975 · S/N 28-7515298 N33673Borregard Robert Stephen · San Jose, CAS/N 28-7515306 N33674Beaulieu Marc R · Lewiston, MES/N 28-7525222 N33676Bous Harry John · Cayce, SCBuilt 1975 · S/N 28-7525224 N33679North Star Aviation Inc · Ulysses, KSFirst renewal noticeBuilt 1975 · S/N 28-7505167 N3367PJackson Lee Roy Jr · Needville, TXBuilt 1958 · S/N 23-1324 N3368TTuley Richard L · Marietta, GARegistration revokedBuilt 1967 · S/N 17700668 N3368ZWatts Paul D · Weatherford, TXBuilt 1960 · S/N 22-7283 N33691Wide Open Aviation LLC · Kalispell, MTBuilt 1975 · S/N 28-7525227 N33692Horn Justin L · Hearne, TXBuilt 1975 · S/N 28-7505170 N3369ERustmann Richard E · Willimantic, CTBuilt 1978 · S/N 17271520 N3369TBauer Charles · Graceville, MNS/N 17700669 N336AFLaine Carey E · Nevada City, CABuilt 1972 · S/N 17260404 N336BWAllen Scott L · Ogallala, NEBuilt 2001 · S/N 4352 N336DBGustafson Gary E · Motley, MNBuilt 2005 · S/N 90805 N336NSky West Aviation Inc Trustee · Albuquerque, NMBuilt 2007 · S/N 120M N336PAWingsleasing LLC · Wichita, KSBuilt 2002 · S/N 4496140 N336RABrown Donald B · Virginia Beach, VABuilt 1978 · S/N 3098 N336RVVose Kristin M · Bloomington, ILBuilt 2001 · S/N 60199

Back to AD 80-04-03 R2