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.

N521KMMcmorries Kyle P · Nacogdoches, TXBuilt 1984 · S/N 21064868 N521SCHarrison Ted W · Grapevine, TXBuilt 1977 · S/N 21062343 N521TKCato Air LLC · Wilmington, DEBuilt 2005 · S/N 18281673 N521VTSeaplanes R Fun Inc · Wilmington, DEBuilt 1957 · S/N 50055 N52204Rench Eugene G · Owosso, MIS/N 18262452 N5220AMarshall Chadwick J · Fort Walton Beach, FLBuilt 2002 · S/N 18281149 N5220EMcgee Kirk S · Anchorage, AKBuilt 1959 · S/N 50520 N52213Rosner Peter · Acton, MABuilt 1973 · S/N 18262457 N52214Peterson Todd W · Beavercreek, ORBuilt 1973 · S/N 18262458 N52225Robinett Douglas · Laguna Niguel, CABuilt 1973 · S/N 18262466 N52226Kettell Merrilee · Eureka, MTBuilt 1973 · S/N 18262467 N5222ESmith Nathan C · Kenai, AKBuilt 1959 · S/N 50522 N5223AGeneral Plumbing Inc · Walnut Creek, CABuilt 1979 · S/N 21063316 N5223MGraham Holdings Inc · Atherton, CANon-citizen corporation, flight hours not reportedBuilt 2002 · S/N 20608180 N5224DMoreland Aviation Enterprises Inc · Byron, ILBuilt 1957 · S/N 50122 N5224NCasper James R · Decorah, IABuilt 1980 · S/N 18267581 N5224UNeil Anthony Foster Holdings LLC · Santa Rosa, CABuilt 1964 · S/N 206-0224 N52251Sims Robert M · Mc Ewen, TNBuilt 1973 · S/N 18262485 N52253Blue Viking Enterprises LLC · San Jose, CABuilt 1973 · S/N 18262487 N52255Springville Flying Club · Spanish Fork, UTBuilt 1973 · S/N 18262488 N52256Hutchinson Scott N · Broadlands, VAS/N 18262489 N5225ERowland Taylor · Wasilla, AKBuilt 1959 · S/N 50525 N5225LFirst Aero LLC · Edmonds, WABuilt 2002 · S/N 18281151 N5225NBartlett Joseph L · Eugene, ORBuilt 1980 · S/N 18267582 N5225REnright Darren · Lakeville, MNBuilt 2002 · S/N 18281152 N5225VKuhn Chad · Boulder, WYBuilt 1975 · S/N 21060867 N5226NGriffin Franklin Todd · Grand Junction, COBuilt 1980 · S/N 18267583 N5226UJohnson Stephen M · Westlake, TXBuilt 1964 · S/N 206-0226 N5227SDcrss LLC · Marcy, NYBuilt 2009 · S/N 18282155 N5228NMiller Kenneth M · Capistrano Beach, CABuilt 1980 · S/N 18267584 N5228UKansas Aviation Museum · Wichita, KSS/N 206-0228 N5228VDynamite Marketing Inc · Meridian, IDBuilt 1975 · S/N 21060870 N522AFState Of Louisiana · Baton Rouge, LABuilt 2003 · S/N 18281195 N522CSKarpinski Arthur A · Jordan, NYBuilt 2016 · S/N 18282422 N522GHQuailridge Aviation LLC · Clarkston, WABuilt 1979 · S/N 21063399 N522LMutai Samson Kipruto · Lenexa, KSBuilt 1960 · S/N 57516 N52301Harmes Brian M · Harrisburg, PABuilt 1973 · S/N 18262515 N52304Haney Michael W · Tehachapi, CABuilt 1973 · S/N 18262516 N52305Ada Forestry Division · Malvern, ARBuilt 1973 · S/N 18262517 N52306Scott Construction Inc · Lake Delton, WIBuilt 1973 · S/N 18262518 N52308Registered aircraftBuilt 1973 · S/N 18262520 N5230EBrentco Aerial Patrol Inc · Canton, OHBuilt 1983 · S/N 18268301 N5230NHostetler Todd · Wausau, WIBuilt 1980 · S/N 18267586 N5230UAllen Etienne · Simi Valley, CABuilt 1964 · S/N 206-0230 N52314Universal Aviatiors Academy Inc · El Monte, CABuilt 1973 · S/N 18262521 N52318Shephard Donald · Lake Havasu City, AZBuilt 1973 · S/N 18262524 N5231DDixon Douglas C · Anchorage, AKBuilt 1958 · S/N 50129 N5231NBrothers Implement Co Inc · Hillsboro, TNBuilt 1980 · S/N 18267587 N5231TRegistration Pending · Cottonwood, AZRegistration pendingBuilt 1981 · S/N R18201839 N52321Kowal Steven K · Annapolis, MDBuilt 1973 · S/N 18262526

Back to AD 84-10-01 R1