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.
N69CJBeech 36 · S/N E-15N6DFGrumman G-21A · S/N B-128N703KAFoxair KITFOX LIGHT SPORT · S/N KA08089130N7053BPiper PA-22-150 · S/N 22-4307N70582Cessna 182M · S/N 18259312N709BABombardier CL-600-2B16 · S/N 5811N71404Silvaire LUSCOMBE 8E · S/N 2831N7141WPiper PA-28-180 · S/N 28-945N7160QCessna 172L · S/N 17260460N7181TCessna 172A · S/N 46781N728LMPilatus PC-12/47 · S/N 728N734EZCessna 172N · S/N 17268809N74PBCessna 414A · S/N 414A0828N756EZCessna TR182 · S/N R18201058N7652BBellanca 14-19-2 · S/N 4003N772KHSocata TBM 700 · S/N 168N7780XCessna 172B · S/N 17248280Registration pendingN778YSJerry Karlsberg VANS AIRCRAFT RV-14A · S/N 140158N79004Cessna 172K · S/N 17257801N79207Cessna 172K · S/N 17257961N7HUPiper PA-30 · S/N 30-1710N800LBCanadair CL-600-2B16 · S/N 5361N8139YPiper PA-30 · S/N 30-1250N8301ACessna 170B · S/N 25153N8358DBeech J35 · S/N D-5524N866DLBellanca 17-30A · S/N 74-30623N8673NPiper PA-32-300 · S/N 32-7240017N86FLBeech B50 · S/N CH-96N8727SCessna 150F · S/N 15062027N880LBLindstrand Balloons 90A · S/N 5325N8824TCessna 182C · S/N 52724N8907FPiper PA-28R-201T · S/N 28R-7703007N895KFTimothy Petsche 7 · S/N 570505082N89GMMiller Gregory Val VANS RV-8 · S/N 80762N90403Rintamaki Peter A SUPER T · S/N R-001N91546Cessna 182M · S/N 18259812N9188WPiper PA-28-235 · S/N 28-10846N9296FRans S-12XL · S/N 01000901N9380UCessna 150M · S/N 15078329N94466Curtiss Wright P-40E · S/N AK-899N945MCCessna 172S · S/N 172S10945N95KSAviat A-1 · S/N 1183N9617KStinson 108-2 · S/N 108-2617N966WAPilatus PC-12/47E · S/N 1911N969SFMarney Don CORBEN BABY ACE · S/N 8969N9771Reid Lennon S SPORTSMAN GS-2 · S/N 7319N9822HCessna 182R · S/N 18268051N9845BBellanca 14-19-2 · S/N 4095N990MKZenith ZODIAC CH601XL · S/N 6-6717N9965UGrumman American Avn. AA-5A · S/N AA5A0365
Back to Meridian, ID