Skip to content

Registered aircraft · 20,483

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.

N35VHBarr Air Patrol LLC · Mesquite, TXBuilt 1981 · S/N 18268129 N35WD4lo Air & Land LLC · Damascus, ORS/N 2050234 N35WSRegistered aircraftS/N R18200346 N35XTWrench John D · Los Olivos, CABuilt 1978 · S/N 18266390 N35ZQZq Navigation LLC · Bellingham, WABuilt 2023 · S/N 18283244 N3600URiera Jose Gregorio · Saint Augustine, FLBuilt 1963 · S/N 18255000 N3601CLloyd Land Plane IV LLC · Brighton, COBuilt 1954 · S/N 31099 N3601YFirst Cut Excavation LLC · Hamilton, MTBuilt 1962 · S/N 21058101 N3602UBritsch Michael J · Anchorage, AKS/N 18255002 N3602YMissionary Aviation Repair Center · Soldotna, AKBuilt 1962 · S/N 21058102 N3603YCarter Duane Lee · Madison, GABuilt 1962 · S/N 21058103 N3604CCosby Asa L · Weldon, CABuilt 1954 · S/N 31102 N3605CChambers Joseph B · Oswego, NYBuilt 1954 · S/N 31103 N3605YVita Clean Services · Wenatchee, WABuilt 1962 · S/N 21058105 N3606CHendrix Grant Mcmahill · University Place, WABuilt 1954 · S/N 31104 N3607UHastings Flyers LLC · Hastings, NES/N 18255007 N3607YHlavnicka Timothy D · Haines, AKS/N 21058107 N3608URegistration Pending · Homer, AKRegistration pendingBuilt 1963 · S/N 18255008 N360ACAlpha Charlie LLC · Post Falls, IDBuilt 1975 · S/N 18263631 N360CPCivil Air Patrol · Maxwell Afb, ALBuilt 2005 · S/N 18281519 N360DLTorgerson Management Inc · Turtle Lake, WIS/N U20606033 N360ECdw Flyers LLC · Kinnelon, NJBuilt 2022 · S/N 18283198 N360JBSouthpark Partnership Ltd · Cullman, ALBuilt 1975 · S/N 18264476 N360MEB L T 360 Aviation LLC · Dalhart, TXBuilt 2000 · S/N 18280849 N360MWMission Wings International Inc · Salem, OHS/N P206-0572 N360RJOliver Paul D · Bozeman, MTBuilt 1964 · S/N 206-0225 N3611CNicoll Steve · Bozeman, MTBuilt 1957 · S/N 31109 N3612CLipka Will · Center Point, TXBuilt 1954 · S/N 31110 N3613CSchneiderhan Edward F · Laurium, MIS/N 31111 N3613UN3613u LLC · Lakeland, FLBuilt 1963 · S/N 18255013 N3614UT Yowonske Enterprises LLC · Rostraver Township, PAS/N 18255014 N3614YEmission -Air Inc · Lexington, NCBuilt 1962 · S/N 21058114 N3615CMarkwardt Jacquelyn K · Santa Cruz, CABuilt 1954 · S/N 31113 N3616UHatch Koay A · Gilbert, AZBuilt 1963 · S/N 18255016 N3616YAnderson Dana R · Redding, CABuilt 1962 · S/N 21058116 N3617YSchindele Micheal D · Tolna, NDBuilt 1962 · S/N 21058117 N3618CHoshor Matthew David · Wetumpka, ALBuilt 1978 · S/N R18200278 N3619CHamby Michael R · Parma, IDBuilt 1954 · S/N 31117 N3619JFisher Ag Service LLC · Cardington, OHBuilt 1979 · S/N T18803565T N3619YWilliams Jimmy Z · Sherman, TXBuilt 1962 · S/N 21058119 N361DBLcb Leasing · Manassas, VAFirst renewal noticeBuilt 2010 · S/N 18282245 N361DCSky West Aviation Inc Trustee · Albuquerque, NMS/N U20605584 N361TEBald Knoll Aviation LLC · Cliff, NMBuilt 1998 · S/N 18280162 N361TKReckless Air LLC · Greenback, TNBuilt 2019 · S/N 18283085 N3620CSnohomish Flying Service Inc · Snohomish, WABuilt 1978 · S/N R18200279 N3621CAirplane 1 LLC · Warren, NHBuilt 1978 · S/N R18200280 N3621UStewart Gary T · Friendswood, TXBuilt 1963 · S/N 18255021 N3621YRegistered aircraftBuilt 1963 · S/N 21058121 N3622UDegonia Gerald · Plainfield, ILBuilt 1963 · S/N 18255022 N3624CMeadows Marcus M · Anchorage, AKBuilt 1954 · S/N 31122

Back to AD 84-10-01 R1