Skip to content

AD 2000-25-02 R1

Registered aircraft · 7,563

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:2000-25-02-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:2000-25-02-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:2000-25-02-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:2000-25-02-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:2000-25-02-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:2000-25-02-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.

N84273Olympic Flight Museum · Olympia, WABuilt 1946 · S/N 7AC-2965 N84276Farnham Aviation Services LLC · Ames, IAS/N 7AC-2969 N84281Clarke Casey D Trustee · Gorham, NHBuilt 1946 · S/N 7AC-2975 N84286Steffens Gerald J · Seymour, WIBuilt 1946 · S/N 7AC-2980 N84290Henley Clint A · Manchester, TNBuilt 1946 · S/N 7AC-2984 N84292Farrell Arlene D · Schroon Lake, NYFirst renewal noticeBuilt 1946 · S/N 7AC-2986 N84294Champ294 LLC · Maumelle, ARBuilt 1946 · S/N 7AC-2988 N84295Sharpe Becky L · Neenah, WIBuilt 1946 · S/N 7AC-2989 N84296Spuza Dan D · Sanger, TXBuilt 1946 · S/N 7AC-2990 N842ACSummit Aeronautics LLC · Dania, FLFirst renewal noticeBuilt 1999 · S/N 842-99 N842CHHall Kenneth C · Durham, NCBuilt 2007 · S/N 1043-2007 N842CSSomerville James P · Anchorage, AKBuilt 1992 · S/N 670-92 N842LBBlair Lynward E · Headland, ALBuilt 1976 · S/N 252-76 N84303Center State Aircraft LLC · Dover, DEBuilt 1946 · S/N 7AC-3000 N84304Ennis Shannon E · Chesapeake, VABuilt 1946 · S/N 7AC-2999 N84306Petes Flight Inc · La Porte, INBuilt 1946 · S/N 7AC-3001 N84310Porter Kelton B · Homer, AKBuilt 1946 · S/N 7AC-3004 N84312Goodman Ronald A · Dos Palos, CABuilt 1946 · S/N 7AC-3007 N84314Crooke Michael J · Charlotte, NCBuilt 1946 · S/N 7AC-3009 N84315Puckered Penguin LLC · Houston, TXBuilt 1946 · S/N 7AC-3012 N84318Unertl Mark H · Waupaca, WIBuilt 1946 · S/N 7AC-3018 N84319Connell Flying Service Inc · Decorah, IABuilt 1946 · S/N 7AC-3013 N84320Falls Dennis A · Olathe, KSBuilt 1946 · S/N 7AC-3014 N84321Hintz Courtney N · San Antonio, TXBuilt 1946 · S/N 7AC-3015 N84325Machen Scott T · Tehachapi, CABuilt 1946 · S/N 7AC-3019 N84328Womack David B · Hurst, TXBuilt 1946 · S/N 7AC-3025 N84334Murphy Jr Robert T · New Fairfield, CTBuilt 1946 · S/N 7AC-3030 N84357Mctaggart Briar C · Adelanto, CAS/N 7AC-3051 N84360Jackson Jon T · Chester, MDBuilt 1946 · S/N 7AC-3054 N84362Logan Stephen E · Gilliam, LAS/N 7AC-3057 N84373Mccullough Jacob D · Lockhart, TXBuilt 1946 · S/N 7AC-3068 N84374Watson Bobby · Hoxie, ARBuilt 1946 · S/N 7AC-3064 N84389Coxbill Clifford E · Okeechobee, FLBuilt 1946 · S/N 7AC-3086 N84393Poole David W · Indianapolis, INBuilt 1946 · S/N 7AC-3088 N84399French Richard A · Newport, NCS/N 7AC-3094 N84405Kroenlein Donald G · Moweaqua, ILBuilt 1946 · S/N 7AC-3100 N84406Mio William A · Intl Falls, MNBuilt 1946 · S/N 7AC-3080 N84407Pyrrhuloxias LLC · Tallahassee, FLS/N 7AC-3108 N84411Registered aircraftBuilt 1946 · S/N 7AC-3104 N84417Favell John P · East Bridgewater, MABuilt 1946 · S/N 7AC-3111 N84418Brodine Alan H · Rochester, NYBuilt 1946 · S/N 3119 N84421Austin James M · Ft Worth, TXBuilt 1946 · S/N 7AC-3116 N84423Snyder David · Port Saint Lucie, FLBuilt 1946 · S/N 7AC-3121 N84426Hopkins Daniel E · Austin, TXBuilt 1946 · S/N 7AC3123 N84427Wieman Dianne L · Marion, TXFirst renewal noticeBuilt 1946 · S/N 7AC-3124 N84428Warner James B Jr · Lincoln, NEBuilt 1946 · S/N 7AC-3128 N84430Huizenga Larry O · Minot, NDBuilt 1946 · S/N 7AC-3127 N84431Petrie Robert J · Eagleville, TNBuilt 1946 · S/N 7AC-3134 N84433Willis James Roger · Belleview, FLBuilt 1954 · S/N 7AC-3131 N84443Registration Pending · Wheatland, CARegistration pendingBuilt 1946 · S/N 7AC-3143

Back to AD 2000-25-02 R1