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.

N3156RChamplain Robert F · Canton, ILBuilt 1967 · S/N 18258556 N3156XBack Country Aviation LLC · Jupiter, FLS/N 20700376 N3156YGrant Robert N · Pollock Pines, CABuilt 1962 · S/N 18254156 N3157QVowell Gregory · Coffeyville, KSBuilt 1967 · S/N 18258157 N3157UDavison Cornelius Harry Jr · Phoenix, AZBuilt 1962 · S/N 18254557 N3158FTw Enterprises Inc · Naperville, ILBuilt 1966 · S/N 18257258 N3158RHelms Stephen G · Anchorage, AKBuilt 1967 · S/N 18258558 N3158SBr Aviation LLC · Lewes, DES/N 18255658 N3159FYarbrough Chad · Bloomingdale, GABuilt 1966 · S/N 18257259 N3159RSdmg Signs LLC · Las Vegas, NVS/N 18258559 N315AGAlpert Adam L · Delray Beach, FLBuilt 1981 · S/N 18053196 N315LAZalen LLC · Mercer Island, WABuilt 1964 · S/N 18255127 N315TMSteadman Tony L · Arlington, TXBuilt 1968 · S/N 18259060 N3160LKo Hee Sun · Norwood, NJBuilt 1975 · S/N U20602815 N3160STronier Paul C · Sparks, NVBuilt 1964 · S/N 18255660 N3161CFinzer Melvern K · Naperville, ILBuilt 1954 · S/N 30960 N3161RDeertrack Aviation LLC · Oshkosh, WIBuilt 1967 · S/N 18258561 N3161SKrikorian John R · Fresno, CABuilt 1964 · S/N 18255661 N3161YSleepy Cat Mountain Real Estate Co · Meeker, COBuilt 1962 · S/N 18254161 N3162DMarks Daniel A · Portersville, PABuilt 1955 · S/N 31960 N3162FSkinner Roma L · Ovilla, TXBuilt 1966 · S/N 18257262 N3162RSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1967 · S/N 18258562 N3162SEagle Aircraft LLC · Park City, UTBuilt 1964 · S/N 18255662 N3162USchreiber Charles R · Calexico, CABuilt 1962 · S/N 18254562 N3162YRogers Anthony L · Monrovia, CABuilt 1962 · S/N 18254162 N3163FSchwab Roscoe C III · De Kalb, TXBuilt 1966 · S/N 18257263 N3163SLabrum Andrew K · Boise, IDBuilt 1964 · S/N 18255663 N3163VZak Enterprises LLC · Cortez, COBuilt 1962 · S/N 18254563 N3164DCallahan Robert D · Mesa, AZBuilt 1955 · S/N 31962 N3164QHanson Donald R Jr · Hillsboro, NDBuilt 1967 · S/N 18258164 N3165FFindlay Bruce · Caro, MIBuilt 1966 · S/N 18257265 N3165QNorris Benjamin · Zolfo Springs, FLBuilt 1967 · S/N 18258165 N3165RReds Cable Tv Inc · Washington, NCBuilt 1967 · S/N 18258565 N3165UMetz Martin A · Phoenix, AZBuilt 1963 · S/N 18254565 N3165YFoster John W · Olathe, KSBuilt 1962 · S/N 18254165 N3166CPersinger Paul W · Wasilla, AKBuilt 1954 · S/N 30965 N3166FShelton K Trustee · Perrysburg, OHBuilt 1966 · S/N 18257266 N3166RVarnson Dale B · Brocket, NDBuilt 1967 · S/N 18258566 N3167DOrtlip Stephen A · Kenbridge, VABuilt 1955 · S/N 31965 N3167FGreen James C · Cedar Rapids, IABuilt 1966 · S/N 18257267 N3167SLightning Bolt Aviation LLC · Bozeman, MTS/N 18255667 N3168CRegistration Pending · Anchorage, AKRegistration pendingS/N 30967 N3168DBovee John W Or · San Diego, CABuilt 1955 · S/N 31966 N3168RRunck Russell E · Watertown, MNBuilt 1967 · S/N 18258568 N3168YSkydive Central New York LLC · Weedsport, NYBuilt 1962 · S/N 18254168 N316HCChilders Henry Dr · Lewes, DEBuilt 2024 · S/N 18283270 N316JHNorthern Arizona Investment Group LLC · Prescott, AZBuilt 2004 · S/N 18281345 N316LSC M & N D Inc · Wilmington, DEBuilt 1964 · S/N 18255604 N316MLJump N316ml LLC · East Berlin, PABuilt 1969 · S/N P2060549 N316RWFour States Tire & Service Inc · Cortez, COBuilt 1979 · S/N 21063447

Back to AD 84-10-01 R1