Mcminnville, OR
Registered aircraft · 101
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 = 'OR' AND g.registrant_city = 'MCMINNVILLE' 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 = 'OR' AND g.registrant_city = 'MCMINNVILLE' 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.
N1011FSpektreworks COBALT 110 · S/N 1-011N101RZRay Roger C MIDGET MUSTANG (M-1) · S/N 792N12314Curtiss Wright SEDAN 15-D · S/N 15-D-2214N133LPAerovel FLEXROTOR · S/N 40N1366UCessna 172M · S/N 17267037N144PGRobinson Helicopter R44 II · S/N 12349N147ECPiper PA-23-250 · S/N 27-2399N1550Ryan B1 · S/N 42N155CWCessna 172M · S/N 17265697N181JBCessna 180G · S/N 18051329N185GBCessna A185F · S/N 18502631N18DSPilatus PC-12/47 · S/N 797N18ZQCubcrafters CC11-160 · S/N CC11-00110N203PABell 206L-3 · S/N 51462N20490Cessna 172M · S/N 17261333N212TFVans RV-12 · S/N 120591N2182Sportavia-Putzer FOURNIER R.F.4.D · S/N 4065N2255BNord 3202 · S/N 77N229MBRobinson Helicopter R22 BETA · S/N 4865N232PPLockheed Martin Aeronautics XE25D · S/N 385N240NASpekterworks FALCON · S/N FALCON-1A-202302-G-658N2411FRobinson Helicopter R22 BETA · S/N 0549N2434CCessna 180 · S/N 30734N243NASpekterworks FALCON · S/N FALCON-1A-202302-G-659N24PPLockheed Martin Aeronautics XE25D · S/N 362N288DCColliander Richard VANS RV-8 · S/N 82175N28EVNorth American T-28B · S/N 138334N2996AAerovel FLEXROTOR · S/N 0052N2PQPeters Bernard E QUICKIE Q2 · S/N 2140N3055NRobinson Helicopter R22 BETA · S/N 4168N3211Ryan B1 · S/N 99N33CCNorth American SNJ-4 · S/N 88-13466N350VREurocopter AS 350 B3 · S/N 3715N353JRAirbus Helicopters AS 350B3 · S/N 7975N363PPLockheed Martin Aeronautics XE25D · S/N 363N37603Hughes HK-1 · S/N HK1N37DFDassault FALCON 2000EX · S/N 37N3817ASchweizer SGS 1-26 · S/N 101N390AKRobinson Helicopter R44 II · S/N 12887N4020YArbc Inc DBA Lindstrand 90A · S/N 5793N4379GMcculloch J-2 · S/N 089N441CLImbert Louis RV-4 · S/N 1753N44YARobinson Helicopter R44 II · S/N 10261N4538GRobinson Helicopter R44 · S/N 2036N46471Piper J3L-65 · S/N G31N4755ZPiper PA-22-108 · S/N 22-8311N4773PCessna P210N · S/N P21000102N477CHRobinson Helicopter R22 BETA · S/N 3729N4803GCessna 172N · S/N 17273351N501HLRobinson Helicopter R22 BETA · S/N 2500
Back to Mcminnville, OR