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.

N974RCRafael Cisneros LLC · Wilmington, DEBuilt 1981 · S/N 21064459 N974SGWalters Patrick W · Tallapoosa, GABuilt 1997 · S/N 18280083 N97503Mercury International LLC · Cheyenne, WYBuilt 1979 · S/N 18267114 N97508Sale Reported · Hurricane, WVSale reportedBuilt 1979 · S/N 18267116 N9750GGee Richard L · Seattle, WABuilt 1972 · S/N 18052250 N97513Registration Pending · Colona, ILRegistration pendingBuilt 1979 · S/N 18267117 N9751BDoyle Kevin M · Kenai, AKBuilt 1957 · S/N 50049 N9751GJanes John L Jr · Anchorage, AKBuilt 1972 · S/N 18052251 N97523Rwp LLC · Bloomington, INBuilt 1979 · S/N 18267119 N9752XBirdman Aviation LLC · Indianapolis, INBuilt 1962 · S/N 21058052 N9752ZRocky Pointe Logistics LLC · Hayden, IDBuilt 1982 · S/N U20606644 N97533Associated Pilots Inc · Winchester, MABuilt 1979 · S/N 18267123 N9753VBellamy Mark A · Freeville, NYBuilt 1966 · S/N 188-0203 N97540Popeye And Olives Adventures LLC · Helena, MTBuilt 1979 · S/N 18267127 N97543Carter Michael E · Dallas, GAS/N 18267128 N9754GWings Aircraft Leasing And Services LLC · Wasilla, AKBuilt 1972 · S/N 18052254 N97553Gregor Anthony J · Bethesda, OHBuilt 1979 · S/N 18267129 N9755BRs Specialties LLC · Anchorage, AKBuilt 1957 · S/N 50053 N9755HQualitair LLC Trustee · MichelstadtBuilt 1981 · S/N 18267997 N97563Fenell Jeffrey A · Stahlstown, PAS/N 18267133 N9756VLarson Lynn R · Casselton, NDS/N 188-0206 N97578Utecht Thomas A · Friant, CABuilt 1979 · S/N 18267135 N97580Wardall Wesley David · Ione, CABuilt 1979 · S/N 18267137 N9758HBlue Sky Aviation Association Inc · Readington, NJBuilt 1981 · S/N 18268000 N9758XHernandez Luis Ignacio · Naples, FLBuilt 1962 · S/N 21058058 N97596Aero-Sphere Inc · Longmont, COBuilt 1979 · S/N 18267143 N9759BHernandez Raymond · Burleson, TXBuilt 1957 · S/N 50057 N9759XFlorida Alarm & Security Technologies LLC · Merritt Island, FLBuilt 1962 · S/N 21058059 N975CPCivil Air Patrol · Maxwell Afb, ALBuilt 2007 · S/N 18281975 N975PCBeck Steven · San Clemente, CABuilt 1975 · S/N 18263546 N975SRBrown Tyrone · Fontana, CABuilt 1968 · S/N 18258964 N97601Zapata Michael III · Cary, NCBuilt 1979 · S/N 18267145 N9760XGubler Joseph A · Fairhaven, MABuilt 1962 · S/N 21058060 N97611Bravo Aviation Co · San Antonio, TXBuilt 1979 · S/N 18267147 N9761HBrentco Aerial Patrol Inc · Canton, OHBuilt 1981 · S/N 18268003 N97622Paul A Leep Md P C · Chassell, MIBuilt 1979 · S/N 18267148 N97627Speer Paul B · Vancouver, WABuilt 1979 · S/N 18267150 N9762EBuermann Hank · Brookfield, VTBuilt 1954 · S/N 30799 N9762XMcdonald Daniel P · Canon City, COBuilt 1962 · S/N 21058062 N97633Graham Brown Aircraft Rentals LLC · Wilmington, DEBuilt 1979 · S/N 18267152 N9763BS-3 Aero Ent LLC · Denton, TXBuilt 1957 · S/N 50061 N97640Foutz William R · Farmington, NMBuilt 1979 · S/N 18267154 N9764BPowder Hound LLC · Girdwood, AKBuilt 1957 · S/N 50062 N9764GSicheneder Scott · Wasilla, AKS/N 18052264 N9765XBaer Monte Wayne · Ronan, MTS/N 21058065 N97661Gravity Productions Inc · Redondo Beach, CABuilt 1979 · S/N 18267162 N97672You Are My Sunshine Aviation LLC · Orange, TXBuilt 1979 · S/N 18267165 N97678Walkinshaw Marcus D · Ridgeland, MSBuilt 1979 · S/N 18267166 N9767GCottingham Dwain R · Attica, INBuilt 1972 · S/N 18052267 N9767HSwanson Joseph C · Blairsville, GABuilt 1981 · S/N 18268008

Back to AD 84-10-01 R1