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.

N5045ZHollis Dustin · Pembroke, KYS/N 22-8667 N5046HDavis James E · Belle Fourche, SDBuilt 1949 · S/N 11-928 N5047ZVanvalkenburgh Sidney B · Madras, ORS/N 22-8671 N50490Aty Aviation Inc · Watertown, SDBuilt 1956 · S/N 18-5215 N5049ZHelderman Laban W · Newton, NCBuilt 1961 · S/N 22-8673 N5050HVan Winkle Randy M · Van Buren, MOBuilt 1949 · S/N 11-933 N5050ZSyers Jacob L · Canton, GABuilt 1961 · S/N 22-8674 N5054ZSarver Kevin C · Mineral Wells, TXS/N 22-8678 N5055ZStevens Mark F · Ocean Springs, MSBuilt 1961 · S/N 22-8679 N5056HHoover Michael B · Ridgeland, WIBuilt 1949 · S/N 17-215 N5056ZLacy Scott · El Dorado, ARS/N 228680 N5057YMatyk Andrew J · Chugiak, AKBuilt 1962 · S/N 18-7890 N5058HTyrl Ryan J · Stillwater, OKS/N 11-957 N5059HChase Joshua R · Princeton, MNBuilt 1949 · S/N 11958 N5059ZWarren Kenneth N · Anamosa, IABuilt 1961 · S/N 22-8684 N5060HBastian Richard L · Burns, WYS/N 11959 N5062ZTerpstra Gregory K Trustee · Potosi, MOBuilt 1961 · S/N 22-8687 N5063ZMuehlberg Timothy M · Tuttle, OKBuilt 1961 · S/N 22-8688 N5064ZGregory Trace D · Springfield, MOBuilt 1961 · S/N 22-8692 N50654Skinner Clay T · Dos Palos, CABuilt 1941 · S/N 5-1371 N5065HWells Kris G · Barron, WIBuilt 1949 · S/N 11-965 N50674Garcia Joan M · Orlando, FLBuilt 1941 · S/N 5-1383 N5068HUehlin Ronald L · Oberlin, KSBuilt 1949 · S/N 11967 N5070LHayden Daniel · North Pole, AKBuilt 1978 · S/N 18-7809122 N5070ZMoser Gary A · Van Wert, OHBuilt 1961 · S/N 22-8698 N5072ZMunning Doris E Trustee · Sellersburg, INBuilt 1961 · S/N 22-8701 N5075ZConstantine Stephen B · Anchorage, AKS/N 22-8706 N5076ZBottoms Michael L · Danbury, NCS/N 22-8707 N5078HSorley Dan C · Union, WABuilt 1949 · S/N 11-977 N5078ZPierce Justin P · Conifer, COS/N 22-8709 N5079ZJohnson Sappa Farms LLC · Stamford, NEBuilt 1961 · S/N 22-8710 N5080ZBrazil Joshua B · Omaha, NEBuilt 1961 · S/N 22-8711 N5081HThomas Douten D · Roxbury, MEBuilt 1948 · S/N 11-688 N5081ZTech Mobile LLC · New Windsor, MDBuilt 1961 · S/N 22-8712 N5082HIan Lussier Inc · Owls Head, MEBuilt 1949 · S/N 11-981 N5082ZHuddleston Anthony A · Knoxville, TNBuilt 1961 · S/N 22-8713 N5083HOlson Mark J · North Pole, AKBuilt 1949 · S/N 11-982 N5083ZMorell Patrick J · Byron Center, MIBuilt 1961 · S/N 22-8714 N5084HHrabe Daren L · Chamberlain, SDBuilt 1949 · S/N 11-983 N5085HWeyland Hendrik J · Udall, KSBuilt 1949 · S/N 11-985 N5086ZRichards Curtis A · Troy, MOBuilt 1961 · S/N 22-8718 N5087YHansen Dewayne E · Fairbanks, AKBuilt 1962 · S/N 18-7894 N5088HSharp Frank J III · Windermere, FLBuilt 1949 · S/N 11-989 N5088ZDavis Scott A · Bingham, NEBuilt 1961 · S/N 22-8722 N5092HHall Joshua M · Kenai, AKBuilt 1949 · S/N 11-994 N5093ZSelby Gerald A · Sand Springs, OKBuilt 1961 · S/N 22-8727 N5094ZDugan Garry P · Manvel, NDBuilt 1961 · S/N 22-8728 N5095HRender Thomas R · Eden Prairie, MNFirst renewal noticeBuilt 1949 · S/N 11-991 N5097FGarcia Roberto P · Spring Hill, FLBuilt 1940 · S/N 4919 N5098ZHanlon Ronald J · Seattle, WABuilt 1961 · S/N 22-8734

Back to AD 99-01-05 R1