Skip to content

Registered aircraft · 1,458

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:96-24-17-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:96-24-17-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:96-24-17-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:96-24-17-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:96-24-17-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:96-24-17-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.

N2433XPoklar Norman A · Mount Orab, OHS/N 5160 N2438KSchwister Steven W · Forest Lake, MNBuilt 1947 · S/N 5165 N2442KSpirit Aviation N231az LLC · Austin, TXBuilt 1947 · S/N 5169 N2449KBlack Charles Bernard · Lenoir, NCS/N 5176 N2450KBlue Cloud Aviation LLC · Turlock, CABuilt 1947 · S/N 5177 N2451KWheeler Brian K · Landenberg, PABuilt 1947 · S/N 5178 N2452KCottonwood Flying Club · Rockford, ILBuilt 1947 · S/N 5179 N2453KWalden Taylor G · Pueblo, COS/N 5180 N2455KBrice Beni H · Severna Park, MDBuilt 1947 · S/N 5182 N2456KSpalding Norman C · Sacramento, CABuilt 1947 · S/N 5183 N2457KWayne Alex A · Flowery Branch, GABuilt 1947 · S/N 5184 N2458KEigsti Rodney E Trustee · Friend, NEBuilt 1947 · S/N 5185 N2468KYarbrough Robert D · Cortez, COBuilt 1947 · S/N 5195 N2470KSucich John J · Belleville, MIBuilt 1947 · S/N 5197 N2471KMainero Tanner R · Chehalis, WABuilt 1947 · S/N 5198 N2485KKaplan Samuel · Santa Paula, CABuilt 1947 · S/N 5212 N2486KSolar Joseph R · Punta Gorda, FLBuilt 1947 · S/N 5213 N2487KKing Gary B · Suffolk, VABuilt 1947 · S/N 5214 N2488KBruton Bert L · San Angelo, TXS/N 5215 N2493KPydeski Joseph J · Dunedin, FLBuilt 1947 · S/N 5220 N2494KWilkie David J · Nashua, NHBuilt 1947 · S/N 5221 N2500KSchroder John Ted IV · Walnut Creek, CABuilt 1947 · S/N 5227 N2501KKnudson Eric C · Bozeman, MTBuilt 1947 · S/N 5228 N2503KMcfall Robert Leroy Trustee · Topeka, KSBuilt 1947 · S/N 5230 N2506KMccann Ryan J · Washington, DCBuilt 1947 · S/N 5233 N25100Bragg Scott T · Salem, ORBuilt 1939 · S/N 1024 N25103Eric Forsman · Corvallis, ORBuilt 1939 · S/N 1027 N25106Petro Jerry R · Williamsburg, VABuilt 1939 · S/N 1030 N25108Chakerian Gregory V · Hollister, CABuilt 1939 · S/N 1032 N25119Rupert Judson L · West Milton, PAS/N 1043 N25127Rust Roger · Jerseyville, ILBuilt 1939 · S/N 1051 N25128Holt Kenneth G Jr · Upper Marlboro, MDBuilt 1939 · S/N 1052 N2512KShetter Justin M · Harrisburg, PABuilt 1947 · S/N 5239 N25138Emig Terry L · Casa Grande, AZBuilt 1939 · S/N 1062 N25142King Rachel G · Gainesville, FLBuilt 1939 · S/N 1066 N25144Freeman Roger M · Kingsbury, TXBuilt 1939 · S/N 1068 N25147Prairie Aero LLC · Elgin, ILBuilt 1939 · S/N 1071 N2514KSmith Jeffrey C · Asheboro, NCBuilt 1947 · S/N 5241 N25154Registration Pending · Jamestown, INRegistration pendingBuilt 1939 · S/N 1078 N2515KPatton John W · Mancos, COBuilt 1947 · S/N 5242 N25164Wright Ronald E · Overland, MOBuilt 1939 · S/N 1088 N25165Harkness Kathy A · Denton, MDBuilt 1939 · S/N 1089 N25174Wighton Harold B · Bloomer, WIBuilt 1939 · S/N 1098 N25178Stechschulte George H · Bluffton, OHS/N 1102 N2518KGolden Coast Airways Corp · Carolina, PRBuilt 1947 · S/N 5245 N25215Harkness Kathy A · Denton, MDBuilt 1939 · S/N 1120 N25231Atkinson James A · Bouse, AZS/N 1136 N25236Drake Randy L · Greenfield, INBuilt 1940 · S/N 1141 N25263Smith James G · Cherry Valley, ILBuilt 1940 · S/N 1170 N25264Kleinert John K · Baldwin, GABuilt 1940 · S/N 1171

Back to AD 96-24-17 R1