Meridian, MS
Registered aircraft · 61
Aircraft may not be kept in the town where they are registered. This site does not publish street address information.
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 = 'MS' 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 = 'MS' 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.
N117CAAmerican Champion 7EC · S/N 1008-2007N123BLRaddatz Steve RV-8 · S/N 81238N126TCThunder & Colt Airborne Amer AX8-90 S 2 · S/N 1880USAN1394RPiper PA-18-135 · S/N 18-1983N16BABritt Bookout M16 TANDEM TRAINER · S/N 16202693N1739TPiper PA-28-140 · S/N 28-7125056N1822WBeech V35B · S/N D-9424N1937JRockwell International 114 · S/N 14037N2023ABeech 95-B55 (T42A) · S/N TC-2168N2051BBeech 95-B55 (T42A) · S/N TC-2196N20636Cessna 172M · S/N 17261451N2160TPiper PA-28-180 · S/N 28-7205010N22295Piper PA-32RT-300T · S/N 32R-7887254N2576UBalloon Works FIREFLY 7-15 · S/N F7-828N299PPEmbraer Executive EMB-505 · S/N 50500298N3030RCameron Balloons US V-77 · S/N 6039N30GRCessna 550 · S/N 550-0656N316LPLeslie Pogue SONERAI 2L · S/N 0929204-0704N347PPEmbraer S A EMB-505 · S/N 50500112N373WBLangford Don WAGABOND · S/N 373N4356KRyan NAVION · S/N NAV-4-1356N438SPTextron 525B · S/N 525B0690N4447KRyan NAVION A · S/N NAV-4-1447N4484KRyan NAVION A · S/N NAV-4-1484N4501YCameron Balloons US N-105 · S/N 5845N4505UCessna 150D · S/N 15060505N4577XPiper PA-32-260 · S/N 32-7600004N48773Ryan Aeronautical ST3KR · S/N 1868N50388Taylorcraft DCO-65 · S/N 4811N503MBBrouillette Michael Elric T2 · S/N AU001N5141GAerostar International S57H · S/N S57H-3012N5203KRyan NAVION B · S/N NAV-4-2103BN52625Aerostar International S53A · S/N S53A-3074N526PTFairchild M-62A-3 · S/N FC-47N528CACirrus Design SR22 · S/N 11208N535BAAdkins George W EXPERIMENTAL · S/N BC003N540SBClayton Mark H SKYBOLT · S/N 52361N54199Piper PA46-500TP · S/N 4697164N54257Cessna 172P · S/N 17274932N550GRLancair LC-40-550FG · S/N 40015N601BWRobinson Helicopter R44 II · S/N 14813N608DJDaniel R Johnson QUICKSILVER SPRINT 2 · S/N 0329N6433CAeronca 7BCM · S/N 7BCM-139N65583Cessna 152 · S/N 15281633N66971Cessna 152 · S/N 15281697N675SSCessna 550 · S/N 550-1123N727NFJoe Henry Bryant RV-8A · S/N 0001N7354VCessna R172K · S/N R1722304N786KWaco BSO · S/N 3003N799FWAviat A-1B · S/N 2023
Back to Meridian, MS