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.

N21579Ollison Lewis E · Warrensburg, MOBuilt 1955 · S/N 5-789 N21583Batte Randall · Forest, MSBuilt 1938 · S/N 2436 N2158AHowlett Corey W · Wasilla, AKBuilt 1953 · S/N 18-1873 N21599Hetge Kenneth R · Viola, ARBuilt 1938 · S/N 4-400 N21604Delgaizo Damian A · Andover, NJBuilt 1938 · S/N 2450 N2163ASharp Roscoe A · Deer Park, WAS/N 20-891 N2164AStejskal Frank P · Carmel, INBuilt 1952 · S/N 22-583 N21659Ramin Jeanette J · Houston, TXBuilt 1938 · S/N 2552 N2165ASistrunk Mark W · Ragley, LABuilt 1952 · S/N 22-586 N21661Bracewell Brent E · Zebulon, GABuilt 1938 · S/N 2549 N2166AKnutson Wayne R · Tioga, NDBuilt 1952 · S/N 20-892 N21696Peterson Cristopher M · Yelm, WAFirst renewal noticeS/N 4-481 N2171APfrender Harold R · Orlando, FLBuilt 1952 · S/N 22-590 N2172AMarx David V · Sauk City, WIS/N 22-589 N2173AVose Dylan · Fort Lauderdale, FLBuilt 1952 · S/N 22-593 N2177ADison Eric R · Battle Lake, MNBuilt 1952 · S/N 22-594 N2179ASharon Carl G · Brookshire, TXBuilt 1952 · S/N 22-597 N2180AStout Billy V · Hooker, OKFirst renewal noticeBuilt 1952 · S/N 22-598 N21828Holt Arlin J · Waterford, MEBuilt 1938 · S/N 2613 N2182AMclaughlin Mark S · Cold Brook, NYBuilt 1952 · S/N 22-600 N21831Roberson Carlton L · Williamson, GABuilt 1938 · S/N 2608 N21845Bowers Tanner C · Harrington, DES/N 4-404 N21867Western Antique Aeroplane & Automobile Museum · Hood River, ORBuilt 1938 · S/N 4-410 N2186AConant Stephen A · Nyssa, ORBuilt 1952 · S/N 20-894 N21879Schiestle Jason T · Greenville, PABuilt 1938 · S/N 2657 N218TSullivan Ross A · Saint Helena, CABuilt 1953 · S/N 18-2332 N2191JOefelein William A · Wasilla, AKBuilt 1960 · S/N 18-7185 N2192WRegistered aircraftS/N 22-2605 N2198ACrowl Jack A · Ashton, IABuilt 1952 · S/N 22-615 N219PSClark Gloria L Trustee · Gillette, WYBuilt 1954 · S/N 18-4037 N21HCPope James D · Clarkston, WABuilt 1962 · S/N 18-7711 N21NTreichler Peter C · East Aurora, NYBuilt 1953 · S/N 18-2865 N21NKSchellhaas Micha R · Joshua Tree, CABuilt 1953 · S/N 22-1186 N21PZimmer Katie Lynn · San Antonio, TXBuilt 1958 · S/N 22-6017 N2205ARiggin Flight Service Inc · Madison, SDBuilt 1952 · S/N 18-1881 N2207ASmith David C · Brewster, WABuilt 1951 · S/N 18-1882 N220HTodd Greg A · Visalia, CAS/N 18-7709118 N2213AShort Colton R · Force, PABuilt 1952 · S/N 20-897 N2214ADeuel Arthur B Jr · Williamsport, PABuilt 1952 · S/N 22-621 N2215ABailey Seth E · Coos Bay, ORBuilt 1952 · S/N 22-630 N2216AHolliday Thomas E · Lake City, MIBuilt 1952 · S/N 22-619 N221BCChristman Eric R · Wasilla, AKS/N 18-5570 N221ECCorban James E · Starkville, MSBuilt 1953 · S/N 20-979 N221TMee Dennis M · Portsmouth, NHBuilt 1953 · S/N 18-2335 N2220ANelson David R Trustee · New Richmond, WIBuilt 1952 · S/N 22-638 N2220KLach Richard · Weldon, CABuilt 1957 · S/N 22-5761 N2220PBryant Stephen C · Anchorage, AKBuilt 1955 · S/N 22-3302 N2220XLach Richard · Weldon, CABuilt 1953 · S/N 22-1845 N2222AUnruh Isaac J · Blossom, TXFirst renewal noticeBuilt 1952 · S/N 20-914 N2224N2224 Dnr Inc · Rochester, MNBuilt 1968 · S/N 18-8651

Back to AD 99-01-05 R1