Skip to content

Registered aircraft · 85,620

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:98-21-21-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:98-21-21-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:98-21-21-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:98-21-21-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:98-21-21-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:98-21-21-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.

N2092MRegistration Pending · Augusta, KSRegistration pendingS/N 28-7816250 N2092SMidwest Airmotive Inc · Mount Sterling, KYBuilt 1975 · S/N 21061058 N2092TCarrolls Auto And Aircraft Sales LLC · Muncie, INBuilt 1971 · S/N 28R-7135037 N2092WEarthcirc08 LLC · Chagrin Falls, OHBuilt 1966 · S/N D-8044 N2092XAirx LLC · Warwick, RIBuilt 1979 · S/N 28-7916342 N2092YNiver Michael A · Plymouth, WIBuilt 1962 · S/N 17249592 N20932Registration Pending · Hammond, LARegistration pendingBuilt 1974 · S/N 17263872 N20934Fly Skyhawk Llp · Galena, OHBuilt 1974 · S/N 17263874 N20935White Mark · Cadiz, KYBuilt 1972 · S/N 18261306 N20936Nedbalek Brent · Brenham, TXS/N 18261307 N2093CJerles William R Jr · Roberta, GABuilt 1978 · S/N 32R-7985022 N2093GNew Herschel Dudley Jr · Savannah, GABuilt 1958 · S/N 51393 N2093MAir Cortright LLC · Boyne City, MIBuilt 1977 · S/N 28-7890228 N2093TRollins Wesley F · Clover, SCBuilt 1970 · S/N 28R-7135038 N2093WKliewer Silas M · Ulm, MTBuilt 1966 · S/N D-8039 N2093XWord Kyle Remington · Albuquerque, NMBuilt 1979 · S/N 28-7911140 N2093YSale Reported · Agar, SDSale reportedBuilt 1962 · S/N 17249593 N20940Cirrus Flight Operations Inc · Minneapolis, MNBuilt 1974 · S/N 17263876 N20944Moody Robert L · Ava, MOFirst renewal noticeBuilt 1972 · S/N 18261313 N20946Local News LLC · Janesville, WIBuilt 1972 · S/N 18261315 N20948Wallin Rolf B · Fayetteville, NCBuilt 1972 · S/N 18261316 N2094CAnson Air LLC · Sugar Land, TXBuilt 1978 · S/N 44-7995116 N2094PCampbell John A · Brentwood, TNBuilt 1979 · S/N 32R-7985077 N2094ROtt Rusty S · Sugar Grove, ILS/N 28-5459 N2094TSuzuki Yoshinori · Ames, IABuilt 1970 · S/N 28R-7135039 N2094VCorning James Elmon · Flagstaff, AZS/N 28R-7931109 N2094YHill Karl A · Visalia, CABuilt 1963 · S/N 17249594 N20951Strevels Stephen M · Knoxville, TNBuilt 1974 · S/N 17263879 N20954Hardin John M · Terrell, TXS/N 17263881 N20955Dimich Milan C · La Jolla, CABuilt 1972 · S/N 18261320 N20958Ras Aviation LLC · Elyria, OHBuilt 1978 · S/N 28-7916020 N2095GRegistration Pending · Bozeman, MTRegistration pendingS/N 51395 N2095KCalifornia In Nice Inc · San Jose, CAS/N 44-7995180 N2095PForbes Richard L · Plano, TXBuilt 1956 · S/N 23-683 N2095RTyson John H · Melba, IDS/N 18255295 N2095VMoon Christopher · Guyton, GABuilt 1979 · S/N 28R-7931110 N2095WOnnoh Fred · Oak Harbor, WABuilt 1979 · S/N 28R-7918077 N2095XMiller Michael D · Goffstown, NHBuilt 1965 · S/N 18256195 N2095YJurca John · Punta Gorda, FLBuilt 1962 · S/N 17249595 N20962Fairmont Field LLC · Enid, OKBuilt 1972 · S/N 18261324 N20965Reich Aviation LLC · Loudon, TNBuilt 1974 · S/N 17263883 N20966Gibson Todd W · Madisonville, LABuilt 1972 · S/N 18261327 N20969Kembel Robert D · Saint Ignatius, MTBuilt 1976 · S/N 18503049 N2096ARegistration Pending · Malden, MORegistration pendingBuilt 1978 · S/N 32R-7985001 N2096BN2096b LLC · Buffalo, NYBuilt 1978 · S/N 28-7911008 N2096LMcfarland Bruce R · Newberry, FLBuilt 1978 · S/N 28-7916242 N2096RBeasley Tim · Summerland Key, FLBuilt 1964 · S/N 18255296 N2096TDufur Casey L · Durant, OKBuilt 1971 · S/N 28R-7135041 N2096XSeward Mark · Seattle, WABuilt 1979 · S/N 28-7921007 N20970Hitt James Randy · Blue Springs, MSBuilt 1972 · S/N 18261330

Back to AD 98-21-21 R1