Meridian, ID
Registered aircraft · 150
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 = 'ID' AND g.registrant_city = 'MERIDIAN' 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 = 'ID' AND g.registrant_city = 'MERIDIAN' 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.
N3717VCessna 140 · S/N 14994N3727DCessna 182A · S/N 34427N37SECessna 172R · S/N 17281035N3XYakovlev/Mckinstry YAK 11 · S/N 458519N4003TBeech B23 · S/N M-1109N4028DCessna 182A · S/N 34728N4100Pdps Pzl-Bielsko SZD-45A OGAR · S/N B-827N4102WPiper PA-32-300 · S/N 32-40165N418DECirrus Design SR20 · S/N 2498N419KBEstes Bruce E SKYSTAR KITFOX4-1200 · S/N 1883N41WGCubcrafters CC11-160 · S/N CC11-00228N421SGAviat S-2C · S/N 6059N428JETextron 525B · S/N 525B0543N42WYAviat A-1C-180 · S/N 3112N430NALeading Edge Aerial Tech PV100X · S/N MFR1937510034N450PDGulfstream Aerospace GIV-X (G450) · S/N 4312N4651CNorth American P-51C-10 · S/N 43-25057N465BCLeading Edge Aerial Tech PV100X · S/N MFR1937510033N4726YCessna T210N · S/N 21063994N4814TPiper PA-28-180 · S/N 28-7205199N4899LPiper PA-28-180 · S/N 28-4266N4964KRyan NAVION A · S/N NAV-4-1964N5107FCessna 172H · S/N 17255107N5177WPiper PA-28-180 · S/N 28-212N5228VCessna T210L · S/N 21060870N525PHCessna 525A · S/N 525A0329N5359QCessna 150L · S/N 15073259N5706JCessna P206E · S/N P20600606N5903WPiper PA-28-150 · S/N 28-2967N5962PPiper PA-24-250 · S/N 24-1054N598DBEmbraer EMB-550 · S/N 55020127N59LUDiamond Aircraft Ind DA 42 · S/N 42.AC148N5PCCessna 182Q · S/N 18265656N601PFIvpt IV-PT PROPJET · S/N LIV-503N60750Fairchild M-62A · S/N FX111N60DBDale Berkbigler CCX-2000 · S/N CCX-2000-0032N60UPBrietigam Charles T VANS RV-6 · S/N CTB-3N612PVArbc Inc DBA Lindstrand 105A · S/N 5745N616BGAerostar International S-57A · S/N S57A-3238N6242ECessna 172 · S/N 46342N6243SCessna 150G · S/N 15067043N63DLVans RV-12IS · S/N 12168N6427DNorth American SNJ-4 · S/N 88-14317N6440BCessna T210M · S/N 21062764N654FLPiper PA-28-140 · S/N 28-7125569N6665ZBeech V35B · S/N D-10291N6793FCessna 150F · S/N 15063393N67ZXRuckle Trevor W VANS RV-7 · S/N 70416N68540Bellanca 7GCBC · S/N 383-72N6984GCessna 150L · S/N 15072484
Back to Meridian, ID