Skip to content

Registered aircraft · 99

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:76-05-07-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:76-05-07-R2') 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:76-05-07-R2')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:76-05-07-R2')
  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:76-05-07-R2')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:76-05-07-R2')
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.

N125HBKansas Farm & Ranch Inc · Seneca, KSBuilt 1978 · S/N 367860021 N2315YMid Continent Aircraft Corp · Hayti, MOBuilt 1980 · S/N 36-8002040 N2329YHeppe Andrew S DBA · Turner, MTBuilt 1981 · S/N 36-8160002 N2338XHangar 8 Spray Service LLC · Clark, SDS/N 36-8202007 N2341YFlying G Aviation Inc · Drayton, NDBuilt 1981 · S/N 36-8160010 N2352XFlying G Aviation Inc · Drayton, NDBuilt 1982 · S/N 36-8202012 N2360YEggemeyer Bradford J · Groom, TXBuilt 1981 · S/N 36-8160017 N2407VPiper Aircraft Inc · Vero Beach, FLBuilt 1980 · S/N 36-8002019 N2409VPiper Aircraft Inc · Vero Beach, FLBuilt 1980 · S/N 36-8002020 N2412XMid Continent Aircraft Corp · Hayti, MOBuilt 1982 · S/N 36-8302001 N24410Storm Spraying Service Inc · Webster City, IABuilt 1982 · S/N 36-8302012 N2442VBarts Flying Service Inc · Storm Lake, IABuilt 1980 · S/N 36-8060017 N2451VHatfield Spraying Service Inc · Nunica, MIBuilt 1980 · S/N 36-8002028 N2460VBenson Dustin R · Sheyenne, NDBuilt 1980 · S/N 36-8060024 N3652ERipley Donald W · Uvalde, TXS/N 36-7902043 N3661EPiper Aircraft Inc · Vero Beach, FLBuilt 1977 · S/N 36-7960071 N3676EPiper Aircraft Inc · Vero Beach, FLBuilt 1977 · S/N 36-7960048 N3699EPiper Aircraft Inc · Vero Beach, FLBuilt 1977 · S/N 36-7960050 N3725EWells Flying Services LLC · Holdrege, NEBuilt 1979 · S/N 36-7960055 N3739EPiper Aircraft Inc · Vero Beach, FLBuilt 1978 · S/N 36-7960076 N3760EWells Flying Services LLC · Holdrege, NEBuilt 1978 · S/N 36-7960064 N3785ERegistration Pending · Sabin, MNRegistration pendingS/N 36-7860077 N3801EAcwercs International Inc · Wilmington, DES/N 36-7802006 N3833EValley Spraying Service LLC · Gann Valley, SDBuilt 1978 · S/N 36-7802024 N3837EPiper Aircraft Inc · Vero Beach, FLBuilt 1978 · S/N 36-7960067 N3838EPiper Aircraft Inc · Vero Beach, FLBuilt 1978 · S/N 36-7960068 N3839EPiper Aircraft Inc · Vero Beach, FLBuilt 1978 · S/N 36-7960069 N3945EGeorgeson Troy D · Sheyenne, NDBuilt 1978 · S/N 36-7802066 N3957EAurora Cooperative Elevator Co · Aurora, NEBuilt 1978 · S/N 36-7802069 N3958EJohnson Lynn L · Grafton, NDBuilt 1978 · S/N 36-7802070 N3980EOse Airspray LLC · Thief River Falls, MNS/N 36-8302022 N3982EFresno Westside Mosquito Abatement District · Firebaugh, CABuilt 1979 · S/N 36-7902027 N3993EStorm Spraying Serv Inc · Webster City, IABuilt 1978 · S/N 36-7802052 N410RMRegistered aircraftBuilt 1975 · S/N 36-7560084 N41323Demars Kevin L · Fargo, NDS/N 36-7460001 N4153EGardner Gary A · Estherville, IABuilt 1979 · S/N 36-8002003 N4154EPiper Aircraft Inc · Vero Beach, FLBuilt 1979 · S/N 36-8002004 N4329FStrathman Aerial Spraying LLC · Axtell, KSBuilt 1980 · S/N 36-8060009 N44523Quality Aviation Inc · Marana, AZBuilt 1974 · S/N 36-7460039 N55713Mid Continent Aircraft Corp · Hayti, MOBuilt 1973 · S/N 36-7360007 N55752Snyder Spraying Service Inc · Snyder, OKBuilt 1973 · S/N 36-7360009 N55993Karsenti Ziva · Galesburg, KSBuilt 1973 · S/N 36-7360025 N56635Danley Brothers Inc · Willows, CABuilt 1973 · S/N 36-7360063 N56844Lubben Ryan D DBA · Fergus Falls, MNBuilt 1974 · S/N 36-7460006 N57585Sabbe Bros Flying Service Inc · Maddock, NDBuilt 1975 · S/N 36-7560119 N57589Sabbe Bros Flying Service Inc · Maddock, NDBuilt 1975 · S/N 36-7560122 N57609Lazy T Aviation LLC · Ashland, NEBuilt 1975 · S/N 36-7660009 N57615Newkirk Thomas R · Garland, NCBuilt 1975 · S/N 36-7660014 N57625Stratham Aerial Spraying LLC · Axtell, KSBuilt 1975 · S/N 36-7660022 N57716Fishers Flyings Pipers LLC · Broken Bow, NES/N 36-7660038

Back to AD 76-05-07 R2