Skip to content

Registered aircraft · 20,481

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.

N79180Elk Enterprises Ltd · Colorado Springs, COBuilt 1973 · S/N 18261804 N79182Gmk Aviation LLC · Brighton, MIBuilt 1973 · S/N 18261805 N7918NRhv Flyers Inc · San Jose, CABuilt 1974 · S/N 18263292 N7922CKemmax Holdings LLC · Latham, NYBuilt 1978 · S/N 18266633 N79253Shipe Jacqueline M · Louisville, TNBuilt 1973 · S/N 18261807 N7925VBobcat Scout LLC · Whitefish, MTBuilt 1966 · S/N 18051825 N7926VDoerstling Alexander Wolfgang · Waco, TXBuilt 1967 · S/N 18051826 N7928VCamp Harper LLC · Houston, TXBuilt 1967 · S/N 18051828 N79297Bas Part Sales LLC · Greeley, COBuilt 1973 · S/N 18261810 N7929GJenkins Joseph J Jr · Matthews, NCBuilt 1974 · S/N 18263330 N7929VWatsabaugh Byron D · Gillette, WYBuilt 1967 · S/N 18051829 N792GWSmith Brothers Aviation LLC · Bryan, TXBuilt 2000 · S/N 18280792 N7930VHague Neil C · Wichita, KSBuilt 1967 · S/N 18051830 N79317Bailey James C II · Drummond Island, MIBuilt 1973 · S/N 18261812 N79324Cochrane William R · Paso Robles, CAFirst renewal noticeBuilt 1973 · S/N 18261814 N7933VBarnes Joseph W · Pittsfield, MEBuilt 1967 · S/N 18051833 N7936VFarrey Michael J · Mason, NHBuilt 1967 · S/N 18051836 N7937VSage Charles M Jr · Wasilla, AKBuilt 1967 · S/N 18051837 N7938VHayton James B · Sedro Woolley, WABuilt 1967 · S/N 18051838 N7939VRuhl Daniel J · Bend, ORBuilt 1967 · S/N 18051839 N79408Voorhees Charles Kirker · Tappahannock, VABuilt 1973 · S/N 18261816 N79424Mccutchan Anthony L · Collinsville, OKBuilt 1973 · S/N 18261818 N7942VKing Air Inc · Naknek, AKBuilt 1967 · S/N 18051842 N79439Asm Aviators LLC · Racine, WIBuilt 1973 · S/N 18261820 N79459Resort Region Flying Club LLC · Kalispell, MTBuilt 1973 · S/N 18261821 N7945VN7945v LLC · Wilmington, DEBuilt 1967 · S/N 18051845 N79463Riley Richard G Jr · New Brighton, PABuilt 1973 · S/N 18261825 N79467Horschel Duane D · Springville, NYBuilt 1973 · S/N 18261828 N794CACivil Air Patrol · Maxwell Afb, ALBuilt 2008 · S/N 18282127 N794RGFb Aviation LLC · Minot, MEBuilt 1999 · S/N 18280538 N79522729 Air LLC · Las Vegas, NVBuilt 1973 · S/N 18261832 N7953VRegistered aircraftBuilt 1967 · S/N 18051853 N7955VHancock Glenn · Jackson, GABuilt 1967 · S/N 18051855 N79585Valley Forge Aviators LLC · King Of Prussia, PABuilt 1973 · S/N 18261836 N79586Booth James L · Fort Collins, COBuilt 1973 · S/N 18261837 N79589Aqua Irrigation Technologies LLC · Parma, IDBuilt 1973 · S/N 18261838 N7958VColbern Matthew · Anchorage, AKBuilt 1967 · S/N 18051858 N79590Corrigan Michael D · Hondo, TXBuilt 1973 · S/N 18261839 N79598Keck Shawn M · Santa Cruz, CAS/N 18261840 N7964VNorris John R · Anchorage, AKBuilt 1967 · S/N 18051864 N7969JPegasus Air Ventures LLC · Macedon, NYBuilt 1976 · S/N 18264871 N796HAJatavallabhula Narasimha Sastry · Longview, TXBuilt 2006 · S/N 18281796 N7971VDossenback Kelly · Folsom, CABuilt 1967 · S/N 18051871 N7973VRickman Allen K · Absarokee, MTBuilt 1967 · S/N 18051873 N7978VSlinger LLC · Laramie, WYBuilt 1967 · S/N 18051878 N797CJSteim Joseph M · Shirley, MABuilt 1975 · S/N 18263827 N797LCMeziere Richard A Jr · Boise, IDBuilt 1962 · S/N 205-0046 N797TMMilliren Karl · Thomasville, NCBuilt 1998 · S/N 18280169 N7987VCozad Rebecca G F Trustee · Talkeetna, AKBuilt 1967 · S/N 18051887 N79882Webbs Wildlife Consultants LLC · Park City, MTBuilt 1973 · S/N 18261841

Back to AD 84-10-01 R1