Skip to content

Registered aircraft · 8,920

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:85-02-05-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:85-02-05-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:85-02-05-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:85-02-05-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:85-02-05-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:85-02-05-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.

N9714DVermeire Calvin L · Soldotna, AKBuilt 1959 · S/N 22-6626 N9715DRegistration Pending · Carlton, WARegistration pendingBuilt 1959 · S/N 22-6627 N9716DKappele Arthur J · Crystal River, FLBuilt 1959 · S/N 22-6628 N9716PGreater Boston Soaring Club · Sterling, MABuilt 1975 · S/N 25-7556032 N971FTStrong John Michael · Clarksburg, WVBuilt 1956 · S/N 23-847 N971PASkywest Leasing Inc · St George, UTBuilt 1999 · S/N 4496031 N971RJSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1971 · S/N 39-111 N9720DNauman Scott A · Littleton, COS/N 22-6632 N9722BBosshard Steven A · Midlothian, VABuilt 1966 · S/N 30-1156 N9722DLincoln Land Community College · Springfield, ILBuilt 1959 · S/N 22-6634 N9725DSantine Michael F · Shelby Township, MIBuilt 1959 · S/N 22-6637 N9728DGrizzly Skins Of Alaska Inc · Wasilla, AKBuilt 1959 · S/N 22-6640 N9729DBurr Industries Inc · Keystone Heights, FLBuilt 1959 · S/N 22-6641 N9730DFlood Ashley · Gibbstown, NJBuilt 1959 · S/N 22-6642 N9732DTouzeau Raymond V · Newberg, ORS/N 22-6644 N9733DMcfalls Caleb Parker · York, SCBuilt 1959 · S/N 22-6645 N9735DSkinner Timothy G · Archer, FLS/N 22-6647 N9736DCamp Doug A · Starkville, MSBuilt 1959 · S/N 22-6648 N9736PKnutson Wayne R · Thompson, NDFirst renewal noticeS/N 257556046 N9737DFolkvord Darrel L · Toston, MTS/N 22-6649 N9740DSchilling Michael · Nikiski, AKFirst renewal noticeBuilt 1959 · S/N 22-6653 N9742DJones Adam J · Lucerne Valley, CABuilt 1959 · S/N 22-6655 N9746DLong Verl L · Lewiston, IDBuilt 1959 · S/N 22-6659 N9747DBender Roger J · Overgaard, AZBuilt 1959 · S/N 22-6660 N9749DCaldwell Joel A · Kenai, AKS/N 22-6662 N974APowder River Aviation LLC · Gillette, WYBuilt 1951 · S/N 22-288 N9754DLaney Charles A · Maiden, NCS/N 22-6668 N9757ZWestern North Carolina Air Museum · Hendersonville, NCS/N 226182 N9758DEvans Michael K · Nome, AKS/N 22-6672 N9760DDavis Michael P · Midway, UTBuilt 1959 · S/N 22-6675 N9762DMarshall Marcus D · Georgetown, TXBuilt 1959 · S/N 22-6677 N9762PKnutson Wayne R · Thompson, NDFirst renewal noticeBuilt 1974 · S/N 25-7556072 N9765DPatey Daniel J · Lakewood, CABuilt 1959 · S/N 22-6680 N9766DMayer Gregory B · Fall River Mills, CABuilt 1959 · S/N 22-6682 N9767PVanhorne Robert E · Centralia, ILBuilt 1974 · S/N 25-7556039 N976AZWl Aviation LLC · Boca Raton, FLBuilt 1976 · S/N 27-7654200 N9777PAerial Banners Inc · Pembroke Pines, FLS/N 25-7556089 N977PMFlamoil Wings LLC · Kaiser, MOBuilt 1981 · S/N 44-8107040 N9780PBell Robert A Jr · Scotland Neck, NCBuilt 1974 · S/N 25-7556068 N9785PBurbank Franklin R · Ocala, FLS/N 25-7556096 N978WCXin Han Aviation LLC · Helena, MTBuilt 2000 · S/N 4496041 N97NNAviation Business Corp · Saint Louis, MOS/N 23-435 N97VPAtkins Louis Clifford Jr · Birmingham, ALBuilt 1964 · S/N 30-480 N9802AAtp Aircraft 7 LLC · Wilmington, DEBuilt 2008 · S/N 4496255 N9803DAttitude Aerobatics LLC · Wilmington, DEBuilt 1959 · S/N 22-6690 N9803PLosse Randall J · Wasola, MOBuilt 1975 · S/N 25-7556118 N9804DEngbring Tim · Valmeyer, ILBuilt 1959 · S/N 22-6691 N9806PSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1975 · S/N 25-7556122 N9808DPresho Glen · Hereford, AZBuilt 1959 · S/N 22-6695 N9809PMit Soaring Association Inc · Sterling, MABuilt 1975 · S/N 25-7556123

Back to AD 85-02-05 R1