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.

N45890Rushing Kevin W · Marks, MSS/N 2417 N45893Rout Chester E · Mountain Home, ARBuilt 1946 · S/N 2420 N45896Stegman Robert A · Saint Peters, MOBuilt 1946 · S/N 2423 N45897Taylor Aaron L · Salado, TXBuilt 1946 · S/N 2424 N45903Phenis Christopher · Elkhart, INBuilt 1946 · S/N 2430 N45911Lee Ronald C · Bronwood, GABuilt 1946 · S/N 2438 N45912Parker Henry Reed · Fairbanks, AKS/N 2439 N45924Grateful Endeavors LLC · Sandpoint, IDS/N 2451 N45925Farrell Jack P · Salem, ORS/N 2452 N45930Dorr Martin · Strongsville, OHBuilt 1946 · S/N 2457 N45935Borszich Claude C · Phoenix, AZS/N 2462 N45939Ramin R Fred · Tomball, TXBuilt 1946 · S/N 2466 N45957Boisselle Joe C · White Swan, WAS/N 2484 N45964Terhune Thomas A · Wichita, KSBuilt 1946 · S/N 2491 N45972Schertz Edward J · Cahokia, ILBuilt 1946 · S/N 2499 N45974Ranger Aviation Inc · Burlington, COBuilt 1946 · S/N 2501 N45978Factor James Rodney · El Paso, TXS/N 2505 N45979Kreikemeier Terry L · Garfield, WAFirst renewal noticeS/N 2506 N45983Bedford Dennis L · Auke Bay, AKBuilt 1946 · S/N 2510 N45984Imbrock Timothy M · Nampa, IDBuilt 1946 · S/N 2511 N45991Dooley Steven P · Toughkenamon, PABuilt 1946 · S/N 2518 N45995Southard Hunter · Knob Noster, MOBuilt 1946 · S/N 2522 N45JSJohnson Christopher J · Tacoma, WABuilt 1945 · S/N 1948 N468ALLewis Seth · North Manchester, INS/N 3397 N478TFLuscombe Observer Wp LLC · Dover, DES/N 6691 N47FVVyfvinkel Frederick J · New Smyrna Beach, FLBuilt 1947 · S/N 5504 N4843VVanderhagen Dyrck A · Spavinaw, OKS/N 4464 N48TFFreeman Stephen K · Bartlett, TNBuilt 1948 · S/N 6274 N4PWGoeken William K Trustee · Sanger, TXBuilt 1946 · S/N 2135 N51551Registration Pending · Hartford, SDRegistration pendingBuilt 1946 · S/N 2978 N515SFWebster David H T · Apache Junction, AZBuilt 1946 · S/N 3766 N51828Flannery Robert P · Durango, COBuilt 1947 · S/N 5287 N519SBSassy Brat LLC · Ormond Beach, FLS/N 2595 N527EDDorr Eric J · Piseco, NYBuilt 1949 · S/N 6555 N528NSVanduynhoven Shawn · Trinity, ALS/N 1766 N540RWWilkins Rondal · Riverside, CAS/N 5144 N575DWEastern Stearman Inc Trustee · Leesburg, VABuilt 1947 · S/N 5216 N579MGHaas Sean Francis · Yucca Valley, CAS/N 2479 N5896XQualitair LLC Trustee · MichelstadtS/N 2553 N5990PMoquin Thomas A · Hampshire, ILBuilt 1946 · S/N 2794 N62925L8 Aero LLC · Narberth, PAS/N 3393 N642TSNightingale Matthew · Rancho Cucamonga, CAS/N 4218 N6517BBarnes Sammy D · Taylorsville, NCS/N 4715 N666FKFlaglor Kinner Lanier · Mosheim, TNBuilt 1947 · S/N 5443 N66DJChapman John R · Kalamazoo, MIBuilt 1947 · S/N 5807 N681ARoberts Samuel K · Greenville, ALBuilt 1948 · S/N 5872 N698DKKellogg Darlene R · Kasilof, AKBuilt 1946 · S/N 2225 N71101Beasley Horace E · Columbia, SCBuilt 1946 · S/N 2528 N71103Muszala Robbyn · Tucson, AZBuilt 1946 · S/N 2530 N71115Weyrauch Brandin T · Williston, NDBuilt 1946 · S/N 2542

Back to AD 96-24-17 R1