Skip to content

Registered aircraft · 59

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:92-15-15') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:92-15-15') 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:92-15-15')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:92-15-15')
  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:92-15-15')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:92-15-15')
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 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 N57816North Texas Dusters & Sprayers Inc · Gainesville, TXS/N 36-7660122 N57830Mid Continent Aircraft Corp · Hayti, MOBuilt 1977 · S/N 36-7760003 N57832Sherer Robert O · Hayes, SDBuilt 1977 · S/N 36-7760005 N57834Aircraft Montana LLC · Helena, MTS/N 36-7760006 N57846Boardman Air Services LLC · Henderson, NEBuilt 1977 · S/N 36-7760017 N57859Airmotive Service LLC · Brigham City, UTBuilt 1977 · S/N 36-7760029 N57882Dakota Air Spray LLC · Huron, SDBuilt 1977 · S/N 36-7760044 N57886Bernstein Timothy D · Faith, SDBuilt 1977 · S/N 36-7760048 N59652Aircraft Montana LLC · Helena, MTBuilt 1977 · S/N 36-7760061 N59654Quality Aviation Inc · Marana, AZS/N 36-7760064 N59669Sidney Morgan D · Gloucester, VAS/N 36-7760078 N59678L&M Decuir Inc · Cottonport, LABuilt 1977 · S/N 36-7760090 N59681Aircraft Montana LLC · Helena, MTBuilt 1977 · S/N 36-7760094

Back to AD 92-15-15