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.

N3866CProfessional Pilots Inc · Lowell, INBuilt 1954 · S/N 31014 N3866YMessina Jacob · Copley, OHBuilt 1964 · S/N 21058366 N3867CKrmo Aviation LLC · Duluth, MNFirst renewal noticeBuilt 1954 · S/N 31015 N3867DPrestige Air Worldwide LLC · Seneca, SCBuilt 1957 · S/N 34567 N3867YGallagher Robert B · Rio Oso, CABuilt 1964 · S/N 21058367 N3868DRegistered aircraftBuilt 1957 · S/N 34568 N3868VSwift Stephen D · Flower Mound, TXBuilt 1949 · S/N 7329 N3869DOwens Hay LLC · Crane, ORBuilt 1957 · S/N 34569 N386CPCivil Air Patrol · Maxwell Afb, ALBuilt 2026 · S/N 18283344 N3870DKlad-Air LLC · Catlett, VABuilt 1957 · S/N 34570 N3873GKronfuss Edward P · Bozeman, MTBuilt 1967 · S/N U206-0873 N3873VAthens Air LLC · Athens, TNBuilt 1949 · S/N 7335 N3874GMcfarlane Bradley J · Port Alsworth, AKS/N U206-0874 N3875DJames D Wirt · Goldsby, OKBuilt 1957 · S/N 34575 N3875GBurnett Ross L · Riggins, IDBuilt 1967 · S/N U206-0875 N3876DBurns William Greg · Eloy, AZBuilt 1958 · S/N 34839 N3877VPetersonrandy · Sonoma, CABuilt 1949 · S/N 7339 N3877YGonzo LLC · La Junta, COS/N 21058377 N3878YRegistered aircraftBuilt 1964 · S/N 21058378 N3879DHolberton George L · White City, ORBuilt 1957 · S/N 34579 N387CSDa Aviation LLC · Englewood, COBuilt 2011 · S/N 18282287 N387WYSvp LLC · Missoula, MTBuilt 1977 · S/N 18265614 N3880CGreer Glenn M · Eugene, ORBuilt 1954 · S/N 31028 N3880DWallace David L · Huntersville, NCBuilt 1957 · S/N 34580 N3880YLake Country Aviation LLC · Milledgeville, GABuilt 1964 · S/N 21058380 N3881YNorton Tim C · Danville, VABuilt 1964 · S/N 21058381 N3882GRanier Flight Service LLC · Friday Harbor, WABuilt 1967 · S/N U206-0882 N3884DBryant Melvin Barry · Cascade, IDBuilt 1957 · S/N 34584 N3884VMather Todd A · Huron, OHBuilt 1949 · S/N 7353 N3886DHarper Shawn W · Bayfield, COBuilt 1957 · S/N 34586 N3887DWin Win Aviation Inc · Wake Forest, NCBuilt 1957 · S/N 34587 N3888CBoyce Clayton · Lake Village, INBuilt 1954 · S/N 31036 N3888DAviation Of North Florida LLC · Jacksonville, FLBuilt 1957 · S/N 34588 N3888YDodson Timothy A · Tulare, CABuilt 1964 · S/N 21058388 N388AGGlenn Alan K · Winnie, TXBuilt 1969 · S/N 18260122 N388LCIshawooa Air LLC · Cody, WYBuilt 1965 · S/N 18256441 N388SStarr William E · Eagle River, AKBuilt 1984 · S/N U20606838 N388WAuza Joseph · Casa Grande, AZBuilt 1956 · S/N 33876 N389Donalds Flying Service Inc · Pantego, NCBuilt 1953 · S/N 30085 N3890CBrandt Robert C · Schaumburg, ILBuilt 1954 · S/N 31038 N3890VInternational Air Services Inc Trustee · Carson City, NVBuilt 1949 · S/N 7361 N3890YEllsworth Joseph D Trustee · Salida, COBuilt 1964 · S/N 21058390 N3891CStaple K Aviation LLC · Queen Creek, AZBuilt 1954 · S/N 31039 N3891GTangent Aviation LLC · Oro Valley, AZBuilt 1967 · S/N U206-0891 N3891VKilo Aviation LLC · East Peoria, ILFirst renewal noticeBuilt 1949 · S/N 7362 N3891YCartwright Chris · Yuba City, CABuilt 1964 · S/N 21058391 N3892DWeiss Steven John · Las Vegas, NVBuilt 1957 · S/N 34592 N3893Rhynard Andrew · Fairbanks, AKBuilt 1958 · S/N 50246 N3893CCravens Robert A · Bend, ORBuilt 1954 · S/N 31041 N3893DGardner Jay A · Agua Dulce, CABuilt 1957 · S/N 34593

Back to AD 84-10-01 R1