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.
N1064ALeading Edge Aerial Tech PV35X · S/N 11269N10VXVoorhees Russell Lee RANS S-6S · S/N 06041592N116DBBeresford Damien SABRE TRIKE · S/N 514N1185Cessna A185E · S/N 18501931N1192YAmerican General Acft AG5B · S/N 10039N1195NCurtiss Wright P-40N · S/N 130158N11WTRobert Elson CCX-2000 · S/N CCX-2000-0040N1277WCessna 172S · S/N 172S8846N12TYCessna 172B · S/N 17248030N137AAeropro CZ S R O A240 · S/N 700 24N1505HFirefly Balloons FIREFLY 7-15 · S/N F7-2019N151RHHanks Ron CORBY CJ-1 · S/N 594N1527LFirefly Balloons FIREFLY 8B-15 · S/N F8B-2047N1669Cessna 180 · S/N 31946N1801APiper PA-22 · S/N 22-513N18023Cessna 150L · S/N 15073739N185EFCessna A185E · S/N 18501575N1950ACessna 140A · S/N 15637N19BSRVB Baloes E Inflaveis Ltda SS-30-BS · S/N MAB 2015150N200PAAerostar International XP CLASSIC LTD · S/N XP-3001N201PNMooney M20J · S/N 24-0302N20801Cessna 182P · S/N 18261216N2146BHead Balloons AX8-105 · S/N 379N2204APiper PA-28-236 · S/N 28-7911006N2240Beech D-50 · S/N DH-35N24925Piper J4A · S/N 4-762N2649GCessna 182B · S/N 51949N2697TSix Chuter SR 5XP · S/N SR5XP-2761N26KMCessna T182T · S/N T18208051N2716WMooney M20E · S/N 1025N271ESCessna 525C · S/N 525C0091N28628Luscombe 8A · S/N 1457N2938CCessna 180 · S/N 30838N30127Waco UPF-7 · S/N 5524N301DWWaters Douglas QUICKSILVER GT · S/N GT2801093N30922Balloon Works FIREFLY 8 · S/N F8-417N30YCCubcrafters CC11-160 · S/N CC11-00442N314THBrent A Smith KITFOX SS · S/N 003Registration pendingN315MCCirrus Design SR22T · S/N 1651N31AMMcelroy Alfred E STITS PLAYMATE SA11A · S/N 108N32105Waco UPF-7 · S/N 5737N3286LCessna 172H · S/N 17256186N3294MPiper PA-12 · S/N 12-2142N3327WPiper PA-32-260 · S/N 32-162N333PKKormylo Philip C RV6-A · S/N PK-2N3417XMooney M20E · S/N 1116N34967Cessna 177B · S/N 17702120N350BCIssoire Siren PIK-30 · S/N 716N357JDFlight Design CTSW · S/N 07-02-09N369XXExtra Flugzeugproduktions UND EXTRA NG · S/N NG063
Back to Meridian, ID