Skip to content

Registered aircraft · 10,638

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.

N1120UNistler Matthew J · Three Forks, MTBuilt 1959 · S/N 186723 N1121CSupercub LLC · Ormond Beach, FLBuilt 1953 · S/N 182221 N1121WDeleon Joseph M · Saint Petersburg, FLBuilt 1947 · S/N 12-2429 N1123AWiplinger Robert D · Inver Grove, MNBuilt 1951 · S/N 18-716 N1123CTuschhoff Stetson Rd · Jackson, MOBuilt 1953 · S/N 22-960 N1123EVonimhof Rudolph F · Anchorage, AKBuilt 1979 · S/N 18-7909062 N1124Bollinger Karen S · Fairbanks, AKBuilt 1955 · S/N 18-3985 N1124CBukowski Bruno · Phoenix, AZBuilt 1953 · S/N 22-966 N1125CCrosta Michael A · Sugar Grove, ILBuilt 1953 · S/N 20-958 N1127ASerie Dennis P · Chugiak, AKBuilt 1950 · S/N 18-720 N11284Horton Rick S · Plains, MTBuilt 1956 · S/N 18-4737 N1128ACarson Dean B · Anchorage, AKBuilt 1951 · S/N 18-721 N1129Houghton John D · Palmer, AKBuilt 1954 · S/N 18-4022 N1129ABredin William B · Anchorage, AKBuilt 1951 · S/N 18-722 N112BFRobbins Dale R Trustee · Medicine Bow, WYBuilt 1968 · S/N 18-8692 N112JCHammerle Edward A · Schuyler Lake, NYBuilt 1961 · S/N 18-7704 N112KFHiggins Timothy T · Seattle, WAS/N 18-7809134 N112PATaylor Jay S · Anchorage, AKBuilt 1947 · S/N 12-2158 N1130Kennedy William · Sheffield, TXBuilt 1954 · S/N 18-3510 N1130ACoxon William O IV · Church Hill, MDBuilt 1951 · S/N 18-723 N1130CLaw David L · Derby, KSBuilt 1953 · S/N 22-965 N1131ARizzo Christian · Clover, SCBuilt 1951 · S/N 18-725 N1132CWinaught Michael A · Louisville, TNBuilt 1953 · S/N 22-969 N1133Cub N1133 LLC · Logan, UTBuilt 1954 · S/N 18-3558 N1136Ekstrom Eric S · Eagle River, AKS/N 18-4041 N1136CCarruthers Steven L · Livingston, TNBuilt 1953 · S/N 22-972 N113CWDawson John W · Milton Freewater, ORBuilt 1946 · S/N 11-3 N113PATundra Aviation Inc · Casselton, NDBuilt 1948 · S/N 14-113 N113PJLang Carl · Harper, TXBuilt 2003 · S/N 9957CC N113SCChief Aviation LLC · Azle, TXBuilt 1952 · S/N 18-2003 N114Cooper Michael D · North Turner, MEBuilt 1954 · S/N 18-3937 N1140CAtkins Alvin R · Barnstead, NHBuilt 1953 · S/N 22-973 N1144AKramer John Edward · Conroe, TXBuilt 1951 · S/N 18-737 N1148ATyrrell Luke L · Fairbanks, AKBuilt 1951 · S/N 18-742 N1149AFodor Scott M · Barryton, MIBuilt 1951 · S/N 18-743 N114CMCunningham Terence R · Santa Barbara, CABuilt 1977 · S/N 18-7709146 N114TAviation Training Solutions LLC · Hilo, HIBuilt 1952 · S/N 18-2228 N1150AMountain Air Spray Company · Craig, COBuilt 1951 · S/N 18-744 N1151ALangdon William W · Lebanon, ORBuilt 1951 · S/N 18-745 N1152CTaylor Jimmie D · Hedley, TXBuilt 1953 · S/N 18-2210 N1153AHolder Robert W · Pittsfield, PABuilt 1968 · S/N 18-747 N1154CStewart Daniel C III · Chugiak, AKBuilt 1953 · S/N 18-2212 N1155WState Of Alaska · Dillingham, AKS/N AC101 N1157CCavill Wayne E · Ryegate, MTBuilt 1953 · S/N 18-2458 N115NSMascher Lynn Scott · Chino Valley, AZBuilt 1970 · S/N 18-8910 N1160AAday Bennie J · Las Cruces, NMS/N 18-757 N1161ALindemann Robin · Anchorage, AKS/N 18-2691 N1164CWilliams Allen J · Greybull, WYBuilt 1953 · S/N 22-989 N1166CAmaya Leonardo H · Port Lavaca, TXBuilt 1953 · S/N 22-990 N1167CMountain Bluebird Aviation LLC · Kalispell, MTBuilt 1953 · S/N 22-992

Back to AD 99-01-05 R1