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.

N3929YAinsworth Ryan · Portales, NMBuilt 1964 · S/N 21058429 N392CVBreen James J · Alpharetta, GABuilt 2016 · S/N 18282465 N392MEFrees Media Inc · Livingston, NJBuilt 2000 · S/N 18280873 N392PTCadd James · Burlington, WIBuilt 1958 · S/N 50140 N3930DColovich Barry L · Vernal, UTFirst renewal noticeS/N 34630 N3931DTolman Cory A · Fallon, NVBuilt 1957 · S/N 34631 N3934BMahoney Andrew R · Fairbanks, AKBuilt 1954 · S/N 30148 N3935DHudson Jon P · Bozeman, MTBuilt 1957 · S/N 34635 N3939DRed Baron LLC · Middletown, DEBuilt 1957 · S/N 34639 N3939GThree Niner Gulf L L C · Denver, COBuilt 1967 · S/N U206-0939 N393BThickstun Benjamin Tyler · Wasilla, AKBuilt 1973 · S/N 18052299 N393DW3 Delta Whiskey LLC · Superior, WIBuilt 1979 · S/N U20605261 N393MUsda Forest Service Fepp · Helena, MTBuilt 1964 · S/N 185-0684 N3941DOrchid Aero LLC · Lakewood, COBuilt 1957 · S/N 34641 N3942YBender Andrew J · Greenwood Lake, NYS/N 21058442 N3943DLoudan Christopher D · Trinidad, TXBuilt 1957 · S/N 34643 N3943YStuart Leslie Trustee · Roseburg, ORBuilt 1964 · S/N 21058443 N3944YBrown Pelican Aviation LLC · Ralston, NEBuilt 1964 · S/N 21058444 N3945DBarnett Lance · Fairfield, CAS/N 34645 N3946YMorris Steven A · Houston, TXBuilt 1964 · S/N 21058446 N3947DBellew James W · Pueblo West, COBuilt 1957 · S/N 34647 N3947YRafter Jm Enterprises LLC · Swink, OKBuilt 1964 · S/N 21058447 N3948YSwine Management Service Inc · Long Island, KSBuilt 1964 · S/N 21058448 N394CVBas Part Sales LLC · Greeley, COBuilt 2016 · S/N 18282437 N394RAN Registration Service LLC Trustee · Sanford, NCS/N 21059329 N39501Registration Pending · Phoenix, AZRegistration pendingBuilt 1982 · S/N U206-06452 N3950YCape Fear Aviation Maintenance LLC · Fayetteville, NCBuilt 1964 · S/N 21058450 N3951YRodriguez Coppola Patricio Andres · New Orleans, LABuilt 1964 · S/N 21058451 N3954YStone Clifford F Jr · Corning, CABuilt 1964 · S/N 21058454 N3956DJohnson Justin R · Bonners Ferry, IDS/N 34656 N3956YWilliams John S · Fort Walton Beach, FLBuilt 1964 · S/N 21058456 N3957YRegistration Pending · Midland, TXRegistration pendingBuilt 1964 · S/N 21058457 N3959DRandolph Clinton A · Bullhead City, AZBuilt 1957 · S/N 34659 N3959YRabeneau Dale · Copperopolis, CABuilt 1964 · S/N 21058459 N395CVCivil Air Patrol · Maxwell Afb, ALBuilt 2016 · S/N 18282434 N395STCm Golf LLC · Sacramento, CABuilt 1973 · S/N 18262665 N3960YSeals Clinton F · Warren, ORBuilt 1964 · S/N 21058460 N3961YSmith Edward C · Lecompton, KSBuilt 1964 · S/N 21058461 N3962DMalone Parachute Club Inc · Williston, VTBuilt 1957 · S/N 34662 N3962GJoe Sanchez Farms Inc · Walnut Grove, CABuilt 1967 · S/N U206-0962 N3963DMaplewood Flying Association Inc · Dorset, VTBuilt 1957 · S/N 34663 N3967YBas Part Sales LLC · Greeley, COBuilt 1964 · S/N 21058467 N3968DFallon Jeffrey C · Berlin, MABuilt 1957 · S/N 34668 N3968QTundra Wings Ministries · Wasilla, AKBuilt 1975 · S/N U20603037 N3968YDetray Michael S · Roy, WAFirst renewal noticeBuilt 1964 · S/N 21058468 N3969DNeal Clarence W · Markham, TXBuilt 1957 · S/N 34669 N3969YCayce Dick Lon Jr · Longview, TXS/N 21058469 N396CVCivil Air Patrol · Maxwell Afb, ALBuilt 2016 · S/N 18282435 N396TCG/A Enterprise LLC · Elizabeth, COBuilt 1956 · S/N 32501 N3970GBack Country Flying Experience Inc · Kalispell, MTBuilt 1967 · S/N U206-0970

Back to AD 84-10-01 R1