Bellevue, WA
Registered aircraft · 148
Aircraft may not be kept in the town where they are registered. This site does not publish owners’ street addresses.
Query with SQL
duckdb -csv -c "SELECT g.n_number, g.serial_number, g.year_manufactured, m.manufacturer, m.model, g.status, g.registrant_name, g.registrant_city, g.registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' g LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = g.aircraft_model_code WHERE g.registrant_state = 'WA' AND g.registrant_city = 'BELLEVUE' ORDER BY g.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 g.n_number, g.serial_number, g.year_manufactured, m.manufacturer, m.model, g.status, g.registrant_name, g.registrant_city, g.registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' g LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = g.aircraft_model_code WHERE g.registrant_state = 'WA' AND g.registrant_city = 'BELLEVUE' ORDER BY g.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.
N105USocata TB 10 · S/N 591N11111Smith AEROSTAR 600 · S/N 60-0329-121N11359Northeast Cub SPORTSMAN GS-2 · S/N 7382N126ALPilatus PC-12/47 · S/N 863N13700Kinner SPORTSTER K · S/N 40N138ASSzybowcowy Zaklad Doswiadczaln JANTAR-2A-SZD 42-1 · S/N B-876N1444ACessna P337H · S/N P3370308N14RDPilatus PC-12/45 · S/N 384N14UWFranz Paul A MERLIN GT · S/N 96061N1551QCessna A185F · S/N 18503484N168LWXianghong Li RV-7 · S/N 73916N169EBPiper PA-34-220T · S/N 3449230N17029Porterfield 35-70 · S/N 229N17450Aeronca LC · S/N 2057N1783JCirrus Design SR22 · S/N 3293N18443Dart G · S/N G-6N1848QCessna A185F · S/N 18503493N185DSCessna A185F · S/N 18503827N18914Ryan Aeronautical SCW-145 · S/N 208N1913CCessna 170B · S/N 26058N1958MAirbus Helicopters EC 130 T2 · S/N 8130N1968ZCessna 150C · S/N 15059768N1998JHarlow PJC-2 · S/N 9N206GETextron T206H · S/N T20609536N20746Rearwin 9000-L DELUXE · S/N 637-DN208DZCessna 208B · S/N 208B0717N21362Cessna 182P · S/N 18261587N217GRepublic RC-3 · S/N 797N21WECirrus Design SR22 · S/N 3370N221Cessna 560 · S/N 560-0626N222BACirrus Design SR22T · S/N 0263N228JGSchleicher ASW-28 · S/N 28061N22LBGreat Lakes 2T-1A-2 · S/N 0730N2358Diamond Aircraft Ind DA 62 · S/N 62.C069N2373SCeres Air C31 · S/N 2157854050402N240RGCessna TR182 · S/N R18201783N24GROrchard Richard W MURPHY MOOSE SR3500 · S/N 302SRN2538DCessna 170B · S/N 20690N2610SCessna 337C · S/N 337-0910N268LWShawn Li RV-10 · S/N 41682N268YCessna 310C · S/N 35846N2720TBeech V35 · S/N D-8441N2768CCessna 170B · S/N 26312N276EMMcclenney Erik S RV-14 · S/N 140024N277CECharles M Eriksen ZODIAC CH601HD · S/N 6-3430N2800ANorth American T-28A · S/N 49-1495N28525Fairchild 24W-41A · S/N W40-134N2903VCallair A-3 · S/N 119Registration pendingN2911VCallair A-3 · S/N 127Registration pendingN2915VCallair A-2 · S/N 131Registration pending
Back to Bellevue, WA