Skip to content

Registered aircraft · 20,481

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:84-10-01-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:84-10-01-R1') 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:84-10-01-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:84-10-01-R1')
  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:84-10-01-R1')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:84-10-01-R1')
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.

N5044DCarpenter Corey · Warden, WAS/N 51144 N5047DMarler Don T · Pocatello, IDBuilt 1958 · S/N 51147 N504EAOlympic Jet Inc · Olympia, WABuilt 2000 · S/N 20608133 N504JWPalmer Gary H · San Juan, TXBuilt 1981 · S/N 21064232 N504QChelatna Lake Lodge LLC · Anchorage, AKS/N U2061293 N504SDPate Charles C Trustee · Wichita, KSBuilt 1961 · S/N 18253203 N50504Baker Merlin K · Bradford, OHBuilt 2001 · S/N 18281057 N5051DVincent Wendal J · Geismar, LABuilt 1958 · S/N 51151 N5052DFertic Knute · Oklahoma City, OKBuilt 1958 · S/N 51152 N5053DRancho Equipment Leasing LLC · Brownsville, TXBuilt 1958 · S/N 51153 N5054DK&L Tech Inc · Adams, NEBuilt 1958 · S/N 51154 N5055DBurns Greg K · Pataskala, OHBuilt 1958 · S/N 51155 N5056EHill Kelly · Bagdad, AZBuilt 1958 · S/N 50356 N5057DLatham Travis W · Round Rock, TXBuilt 1958 · S/N 51157 N5058USkyler Aviation Inc · San Diego, CABuilt 1963 · S/N 206-0058 N5059DJk Aviations LLC · Yardley, PABuilt 1958 · S/N 51159 N505ABFredrickson Kenneth · Port Angeles, WABuilt 1974 · S/N 18263391 N505CPCivil Air Patrol · Maxwell Afb, ALBuilt 2019 · S/N 18283070 N505JRParker Matthew · Cloudcroft, NMS/N 18253919 N505LMKennicott Wilderness Air LLC · Glennallen, AKS/N 31267 N505PDSargent Evan · Camas, WABuilt 1971 · S/N 18260611 N505PPOnionaire LLC · Aurora, ILBuilt 2025 · S/N 18283318 N505SWBas Part Sales LLC · Greeley, COBuilt 1976 · S/N 21061185 N5062UEnglish Ryan E · Henderson, NVBuilt 1964 · S/N 206-0062 N5063EAdams James R · Prescott, AZS/N 50363 N5064DPershing Flying Club Inc · Lovelock, NVBuilt 1958 · S/N 51164 N5065DWharton Edwin Scott · Anchorage, AKBuilt 1958 · S/N 51165 N5065ERickman Wanda M · Absarokee, MTBuilt 1958 · S/N 50365 N5066DCurry Timothy S · Salisbury, MDBuilt 1958 · S/N 51166 N5067ERickenbach Rodd L Trustee · Denver, COBuilt 1958 · S/N 50367 N506YZR&R Gray Equipment & Cattle LLC · Enid, OKS/N 21059139 N5071DAcmx LLC · Cedar Rapids, IAS/N 51171 N5072UStopka Alexis L · Belgrade, MTFirst renewal noticeBuilt 1963 · S/N 206-0072 N5074DAhumada George · Palmer, AKBuilt 1958 · S/N 51174 N5074EKauffman Stephen E · Anchorage, AKS/N 50374 N5076EJensen Adam G · Anchorage, AKBuilt 1958 · S/N 50376 N5077DPrentiss Zachary Callan · Grand Junction, COBuilt 1958 · S/N 51177 N5077EWest Elk Air LLC · Gunnison, COS/N 50377 N507DGLynn John Earl Jr · Anchorage, AKBuilt 1977 · S/N U20603680 N507PHocker Matthew Tutt · LondonBuilt 2001 · S/N 18281008 N507SDKnapp Jason D · Schenevus, NYBuilt 1958 · S/N 34950 N5080DJohnson Kenneth J · Red Bluff, CAS/N 51180 N5080EAdams Kenneth C · Neosho, WIBuilt 1958 · S/N 50380 N5080YOptic Air LLC · Maurice, IABuilt 1981 · S/N 18267875 N5082DRegistered aircraftBuilt 1958 · S/N 51182 N5083NN5083 LLC · San Diego, CABuilt 1979 · S/N 18267504 N5084DArrow LLC · Pateros, WABuilt 1958 · S/N 51184 N5085DHawkes Brian R · Hamilton, MTBuilt 1958 · S/N 51185 N5086ANeeley James L · Temecula, CAS/N 21063263 N5086DGillaspy Paul J · Orcutt, CABuilt 1958 · S/N 51186

Back to AD 84-10-01 R1