Skip to content

Registered aircraft · 10,639

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:99-01-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:99-01-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:99-01-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:99-01-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:99-01-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:99-01-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.

N4152AHarms Harvey Dennis · Chugiak, AKBuilt 1989 · S/N 1809040 N4152NAir LLC · Salem, ORS/N 1809028 N4152ZRappe Craig E · Wasilla, AKBuilt 1966 · S/N 18-8400 N41530Dahl Ranch Inc · Camp Crook, SDBuilt 1989 · S/N 1809048 N4153AP B Odom Enterprises Inc · Oklahoma City, OKBuilt 1989 · S/N 1809037 N4153DBarker Bobby G · Gilbert, AZBuilt 1989 · S/N 1809038 N4153HBachman Aviation LLC · Independence, IABuilt 1989 · S/N 1809039 N4153LWinter Karl · Goodyear, AZBuilt 1989 · S/N 1809041 N4153MLincoln Roger Trustee · Gildford, MTBuilt 1989 · S/N 1809042 N4153ZRocky Mountain Motor Service · Dupuyer, MTBuilt 1965 · S/N 18-8331 N4154ASan Saba Management Co LLC · Lakeway, TXBuilt 1989 · S/N 1809049 N4154HKloke Joseph W · South Elgin, ILS/N 17-1 N4154MChapman Cody C · Fairbanks, AKBuilt 1947 · S/N 12-3053 N4154PBoslough Construction Inc · Anchorage, AKBuilt 1989 · S/N 1809045 N4154ZIsham David R · Decatur, TXBuilt 1965 · S/N 18-8333 N41551Plane Services LLC · Twin Falls, IDBuilt 1993 · S/N 1809064 N41552Haley Lawrence E II · Arcade, NYBuilt 1994 · S/N 1809081 N41553Golden Arrow Aviation Inc · Wilmington, DEBuilt 1993 · S/N 1809067 N41556Piper David B · Lake Placid, FLBuilt 1942 · S/N 9045 N41557Mccann John P III · Greenville, PAFirst renewal noticeS/N 1809071 N4155DBaker James J · Cumberland, WIBuilt 1990 · S/N 1809057 N4155LNanartowich Eric V · Galway, NYBuilt 1993 · S/N 1809059 N4155MFirey Charles R · Anchorage, AKBuilt 1947 · S/N 12-3054 N4155RVroom David H · Oro Valley, AZBuilt 1993 · S/N 1809061 N4155TVan Treese Marilyn J · Monte Vista, COBuilt 1993 · S/N 1809066 N4155WSale Reported · Wilbur, WASale reported, canceledBuilt 1993 · S/N 1809063 N41560Shepard John A · Clearwater Beach, FLBuilt 1942 · S/N 9053 N41562Thibault William N Trustee · Newport Beach, CABuilt 1990 · S/N 1809060 N4156NFoothill Aviation LLC · Homer, AKBuilt 1993 · S/N 1809070 N4156VEngelskirger Karl D · Valley City, OHBuilt 1993 · S/N 1809062 N4156ZStaberg Randy W · Powder River, WYS/N 18-8338 N41573Merritt Daniel D · Graham, WABuilt 1994 · S/N 1809085 N41577Horseshoe Bar Land & Livestock LLC · Gillette, WYBuilt 1994 · S/N 1809086 N4157CPatterson Dan DBA · Levelland, TXBuilt 1993 · S/N 1809072 N4157HDhf LLC · Valentine, NEBuilt 1993 · S/N 1809069 N4157LMorton John W · Hurricane, UTBuilt 1993 · S/N 1809073 N4157MBibber Eugene A · Anchorage, AKBuilt 1947 · S/N 12-3056 N4157RMckenna Brothers Aircraft LLC · Anchorage, AKBuilt 1993 · S/N 1809076 N4157TRandel Vernon E · Erie, COBuilt 1994 · S/N 1809082 N4157UAeromarine Holdings LLC · Waukesha, WIBuilt 1993 · S/N 1809078 N4157WBoardman Rick · Henderson, NEBuilt 1994 · S/N 1809083 N4157ZReinbold Frederick Karl · Anchorage, AKBuilt 1965 · S/N 18-8339 N41580Eagle Racer LLC · Boca Raton, FLBuilt 1994 · S/N 1809104 N41587Gary Deborah · Houston, TXBuilt 1994 · S/N 1809105 N4158DBoho LLC · Lewes, DEBuilt 1994 · S/N 1809087 N4158HMann Thomas A · Ford, WABuilt 1948 · S/N 15-41 N4158LJm Lavore Aero Inc · Lakeside, MTBuilt 1994 · S/N 1809100 N4158WButler John P · Hazelhurst, WIBuilt 1994 · S/N 1809102 N4158YAlliance Aircraft Sales Inc · Pierre, SDBuilt 1994 · S/N 1809103 N4158ZSchaetzel Paul Robert · New Meadows, IDBuilt 1965 · S/N 18-8340

Back to AD 99-01-05 R1