Lucedale, MS
Registered aircraft · 36
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 = 'MS' AND g.registrant_city = 'LUCEDALE' 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 = 'LUCEDALE' 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.
N101EZRans Employee Flying Club RANS S-6S · S/N 08071825N10UXSport Aviation Svcs/Smith J ULTRA X · S/N 519N119RSRonald L Smith RANS S-19 · S/N 080800029N11ZZMay Lemuel & May Tim LEZA-LOCKWOOD AIRCAM · S/N AC-094N1395RGrumman American Avn. AA-5 · S/N AA5-0795N143CTFlight Design CTSW · S/N 06-11-08N176FMceachern William F FERGY II B · S/N 00-2B-006N1909FCessna R172J · S/N P17257189N204JAAckerman Joseph W S-6S COYOTEII · S/N 05001369SN212AVVendrell Alex H/Keuthan Avia ZEPHYR II · S/N ZP2-K018N223SESmith John W SF15 EX-CALIBUR · S/N 002N265CDQuicksilver Enterprises MXL II SPORT · S/N 000696N278NSSmith Morris W MXII SPRINT · S/N 02-2022N2956UCessna 172D · S/N 17250556N35108M Squared SPRINT 1000 · S/N 000558N39362Lake LA-4-200 · S/N 519N4628CCessna 170B · S/N 25572N474RLCirrus Design SR22 · S/N 3820N49MPPhelps Thomas H PAZMANY PL 2 · S/N 49N5421LGrumman American Avn. AA-5 · S/N AA5-0321N5615UQuad City Ultralight Acft CHALLENGER · S/N CH2-0201-2054N566ABVendrell Alexander JABIRU CALYPSO · S/N 566N5951LAmerican AA-1 · S/N AA1-0251N654MTTurner Mike W CH 701 · S/N 7-5025N7197LGrumman American Avn. AA-5 · S/N AA5-0697N7220FPiper PA-28-140 · S/N 28-25131N72XTCzech Aircraft Works Spol Sro SPORTCRUISER · S/N 07SC041Registration pendingN750FMMassey Frankie D STOL CH 750 · S/N 75-7468N75434Wettrike WETTRIKE WTA · S/N 104N75437Wettrike WETTRIKE WTA · S/N 105N770SSSmith Ronald L RANS S-7 · S/N 0405400N855RHHarley J Havard QUICKSILVER SPRINT I · S/N MXLII SPORT 000764N8803SSmith Morris W DRIFTER · S/N MS001N9427YBeech N35 · S/N D-6601N999VJSkinner Russell W VIPERJET MK II · S/N 003N99KDDominy Kenneth W RAVEN · S/N 01150033
Back to Lucedale, MS