Subaru ALL MDLS A/B
Registered aircraft · 349
Aircraft with this engine in the FAA registry, by N-number.
Query with SQL
duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE engine_model_code IN ('59050')
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, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE engine_model_code IN ('59050')
ORDER BY n_numberRun 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.
N202VXTanis Ronald D · Tickfaw, LAN2036ECobar Alexis R · Bakersfield, CAN204WDHudson David M · Supply, NCN205AKHull Kirk P · Kansas City, MON2071USohn Richard · Defuniak Springs, FLN2086HKern Raymond L · Bedford, INRegistration expired, pending cancellationN2127WHaney James H · Brooksville, FLN213BFHamann Jason · Eagle Point, ORN2205XDehnert David E · Waterloo, WIN221BPBravo Amado Giovanny · Eagle Lake, FLN22627Stacy Theodore L · Valparaiso, INN2273MGray David M · Albuquerque, NMN2278GVan Pelt Matthew C · Independence, ORN227SBBehrends Steven R · Livingston, TXN229HAWalsh William T · Tumwater, WAN234EEBartlett Charles · Bloomfield, NYN2361SHerriford Richard · Port Saint Lucie, FLN2409FEvink David K · Hancock, MNN240SDMiller Larry G · Sioux Falls, SDN241SFWalcutt Robert · Nocona, TXN2422ASweeney Sean M Jr · Reunion, FLN247AWPerkins William J · Luther, OKN24TUHenderson Robert · Lake Stevens, WAN24TZMenard Keith L · Bellevue, TXN2503WFritts Dofin A · Molino, FLN2511QBaker Steven L · Polk City, FLN2521FFritts Dofin A · Molino, FLN2562YVercruyssen Max · Honolulu, HIN258KBBarber Kenneth M · Onida, SDN25VKIlliana Aero LLC · Vincennes, INN268CCCarlson Paul · Kingsland, GAN2691HHunt William · Bourne, MAN26HCMoore Bradly J · Logsden, ORFirst renewal noticeN271JCCarpenter John H Jr · Malabar, FLN2747TElsbernd Thomas J · Midland City, ALN274WRRead Wayne L · Marble Hill, MON27CFCarson Shaun L · Burley, IDN2NWMiller Timothy · Tellico Plains, TNN3013HBoyle Steve J · Largo, FLN30702Taylor Nicholos C · Intl Falls, MNN3086LGraham Steven W · Caldwell, IDN30982Smith Wayne J · Brookhaven, MSN309RVPerron Kenneth J · Clinton, IAN3116FMoeller Gordon Lee · Tulsa, OKN311WTBie Ernest W Jr · Cincinnati, OHN313BFFlick Ralph W · Williamsport, PAN315THStephens Robert W · Cullman, ALN316DTTyler Randy G · Palmer, AKN318TBDurkin Brian S · Saint Anthony, IDN320GNNeal Gary C · Spartanburg, SC
Back to Subaru ALL MDLS A/B