Skip to content

Registered aircraft · 26,231

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:94-05-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:94-05-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:94-05-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:94-05-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:94-05-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:94-05-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.

N2842UDeshaies Robert · Cumberland, RIBuilt 1963 · S/N 17250442 N2843CPacific Coast Air Museum · Santa Rosa, CAFirst renewal noticeS/N 26386 N2843SRegistration Pending · Tequesta, FLRegistration pendingS/N 15066743 N2843UFlite Five Inc · Kiowa, KSBuilt 1963 · S/N 17250443 N2844SJacks Grady M · Mena, ARS/N 15066744 N2844VN2844 LLC · Riverton, UTBuilt 1974 · S/N 15076298 N2845COsterhout Joshua C · Prineville, ORS/N 26388 N2845HGoff Frederick Myron · Vernon, CTBuilt 1946 · S/N 3470 N2845LShenk Ronald W · Palmetto, GABuilt 1967 · S/N 17256045 N2846CBranstner August M · Taft, CABuilt 1954 · S/N 26389 N2846ESchmid Gerhard G · New Smyrna Beach, FLBuilt 1946 · S/N 7AC-6429 N2847DAlthens Levi W · Wasilla, AKS/N 7BCM-51 N2847EChipman Jeff M · Rising Sun, INBuilt 1946 · S/N 7AC-6430 N2847LGervase Russell · Farmington, NMBuilt 1967 · S/N 17256047 N2847VClinton Flying Service Inc · Clinton, NCBuilt 1974 · S/N 15076299 N2848CBenedict Michael T · Anchorage, AKBuilt 1954 · S/N 26391 N2848EBeckhoff Allen C · Greybull, WYBuilt 1946 · S/N 7AC-6431 N2848NIndy Air Sales LLC · Anderson, INBuilt 1947 · S/N 13108 N2850CToxvard Ludvig E III · Pueblo, COBuilt 1954 · S/N 26393 N2850LBergmann Robert A · Lake Placid, FLBuilt 1967 · S/N 17256050 N2851LMorristown Flying Service Inc · Talbott, TNBuilt 1967 · S/N 17256051 N2852CBrenneman James M · Carrboro, NCBuilt 1954 · S/N 26395 N2852LHardin County Aviation LLC · Kountze, TXBuilt 1967 · S/N 17256052 N2852UWatten Sig V · Rhinelander, WIBuilt 1963 · S/N 17250452 N2854CHazen Alan L · Rifle, COBuilt 1954 · S/N 26397 N2854UGerbig Robert A · Gleason, WIBuilt 1963 · S/N 17250454 N2855CItoi Timotheus Y · Yona, GUBuilt 1954 · S/N 26398 N2855LParis Flight Training LLC · Powderly, TXBuilt 1967 · S/N 17256055 N2855NSchlehr Kenneth P · North Tonawanda, NYS/N 13116 N2856CGermaine David R · West Orange, NJBuilt 1954 · S/N 26399 N2856NPoor Boys Flying Club Incorporated · Osborne, KSBuilt 1947 · S/N 13117 N2856SPerera Nandana L · Logan, OHBuilt 1967 · S/N 15066756 N2856UNguyen Trinh Kieu Thi · Jacksonville, FLBuilt 1963 · S/N 17250456 N2857CHackamore Equipment LLC · Prairie City, SDBuilt 1954 · S/N 26400 N2857LKeller Thomas Joe · Chattanooga, OKBuilt 1967 · S/N 17256057 N2857NGomez Oscar · El Mirage, AZS/N 13118 N2857SCrum Brian B · Warrensburg, MOS/N 15066757 N2857UAuck Allyn L · Fort Mohave, AZBuilt 1963 · S/N 17250457 N2857VCiabattoni David E · Wallingford, PABuilt 1974 · S/N 15076302 N2858LAgile Systems LLC · Simpsonville, SCS/N 17256058 N2858UGelfius Glenn E · Dahlgren, ILBuilt 1963 · S/N 17250458 N2859CWalston Glenn P · Fairbanks, AKBuilt 1954 · S/N 26402 N2859LWheadon William J · Napa, CABuilt 1967 · S/N 17256059 N2859SHout David D · Columbus, OHBuilt 1967 · S/N 15066759 N285JRBorgens L Wyatt · Lowden, WABuilt 2007 · S/N CC11-00016 N2860HKerr Phillip D · Beebe, ARBuilt 1946 · S/N 3485 N2861NJulian Stan T · Holt, FLBuilt 1947 · S/N 13122 N2861SEagley Ronald A · Anchorage, AKBuilt 1967 · S/N 15066761 N2862SGrotbeck Carter L · Albuquerque, NMBuilt 1967 · S/N 15066762 N2862UWallace Jon W · Ozark, ARBuilt 1963 · S/N 17250462

Back to AD 94-05-05 R1