Skip to content

Registered aircraft · 20,683

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:90-06-03-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:90-06-03-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:90-06-03-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:90-06-03-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:90-06-03-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:90-06-03-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.

N6911HHarbour Aviation LLC · Weatherford, TXBuilt 1975 · S/N 17265639 N6911XNorth Georgia Aviation Management Group LLC · Cumming, GABuilt 1960 · S/N 17247811 N6912AKinsey Craig Russell · Sidney, TXBuilt 1956 · S/N 29012 N6912XFahrne John E · Bradley, MIBuilt 1960 · S/N 17247812 N6913XEllis Mark C · Rogers, ARS/N 17247813 N6914XMagee Wayland S · Agency, MOBuilt 1960 · S/N 17247814 N6915ACraig Linda I · East Freetown, MABuilt 1956 · S/N 29015 N6915H2gbs LLC · Wilder, IDBuilt 1975 · S/N 17265640 N6915XWitkowski Terrance G · Winamac, INBuilt 1960 · S/N 17247815 N6916ABloyer Emery · Fennimore, WIBuilt 1956 · S/N 29016 N6916HFms Air LLC · Leesville, LABuilt 1975 · S/N 17265641 N6917XSchumacher Terry L · Wilson, WIBuilt 1960 · S/N 17247817 N6918ALarson Gary W · Fort Worth, TXBuilt 1956 · S/N 29018 N6918HWright Flight Inc · Tucson, AZBuilt 1975 · S/N 17265642 N6918XHackbarth Ryan J · Zimmerman, MNBuilt 1960 · S/N 17247818 N6919HTimmester Terry W · Little River, SCBuilt 1975 · S/N 17265643 N691JATextron Aviation Inc · Wichita, KSBuilt 2026 · S/N 172S13595 N691SPGc Aviation Services-1 LLC · Miamisburg, OHBuilt 1999 · S/N 172S8100 N691TCSpartan National Holdings LLC · Missoula, MTBuilt 1999 · S/N 172S8225 N691WEagle Simulator LLC · Lake Oswego, ORBuilt 1982 · S/N 17275576 N6920XEge David D · Mount Horeb, WIBuilt 1960 · S/N 17247820 N6922XIowa Military Aviation Heritage Museum · Ankeny, IABuilt 1960 · S/N 17247822 N6924AHuempener Gary R · Cato, WIBuilt 1956 · S/N 29024 N6924HJeea Aviation LLC · Tyler, TXBuilt 1975 · S/N 17265647 N6924XAshby Jimmie Thomas · Germanton, NCBuilt 1960 · S/N 17247824 N6925XAdlard Thomas · Spokane, WAS/N 17247825 N6926ATrident Aviation LLC · Kalispell, MTS/N 29026 N6926HJust Plane Adventures Inc · Crystal Lake, ILFirst renewal noticeBuilt 1975 · S/N 17265648 N6927ASmith James C Jr · Fayetteville, GABuilt 1956 · S/N 29027 N6928XN6928x LLC · Sandpoint, IDBuilt 1960 · S/N 17247828 N6929AWadsworth Curtis D · Sierra Vista, AZBuilt 1956 · S/N 29029 N692CPCivil Air Patrol · Maxwell Afb, ALBuilt 2015 · S/N 172S11541 N692SPSmith Holdings Inc · Wilmington, DEBuilt 1999 · S/N 172S8102 N6930AStewart Donald M · Vulcan, MIBuilt 1956 · S/N 29030 N6931XDanford Gary R · Columbus, MSS/N 17247831 N6932AAthey Jerry Jeff · Alvin, TXBuilt 1956 · S/N 29032 N6934XLunar Aviation Services LLC · Owasso, OKS/N 17247834 N6935XDetert Robert D · Rockdale, TXBuilt 1960 · S/N 17247835 N6936AJordahl Amy L · Two Harbors, MNBuilt 1956 · S/N 29036 N6936HQuist Donald G · Ridgecrest, CABuilt 1975 · S/N 17265652 N6937HTreble Holdings LLC · Dover, OHBuilt 1975 · S/N 17265653 N6939AErtas Efe Y · Walnut Creek, CABuilt 1956 · S/N 29039 N693SACaddo Aircraft LLC · Lewes, DEBuilt 2000 · S/N 172S8514 N6940XWestern Aircraft Leasing LLC · Tempe, AZS/N 17247840 N6942AHaskell Thomas L · Summerville, SCBuilt 1956 · S/N 29042 N6943XSkinner Roma L · Ovilla, TXS/N 17247843 N6944EHinds Archie L · Claremore, OKBuilt 1978 · S/N 17272076 N6945XA Team Motors LLC DBA · Henderson, NVBuilt 1962 · S/N 17247845 N6948ASelf David J · Wagener, SCBuilt 1956 · S/N 29048 N6948XWalburg Frank L · Zanesville, OHS/N 17247848

Back to AD 90-06-03 R1