OpenAirDocs.org
Opelousas, LA

Registered aircraft · 30

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 = 'LA' AND g.registrant_city = 'OPELOUSAS'
  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.

N117WVGruber Gerald F GLASAIR III · S/N 3115Built 1990 · Redline Onsite Services LLCN14TWMooney M20C · S/N 670148Allbid IncN16238Cessna 150L · S/N 15073564Built 1972 · Hayes Lance GarettN1672Thomas R Venable EXCALIBUR · S/N 3026Venable Thomas RN167PTLee Santa J EXEC 162F · S/N 6452Built 1999 · Hayes Lance GarettN168JACessna 162 · S/N 16200009Built 2010 · Haynes Gregory PN18555Beech F17D · S/N 157Built 1937 · Wiltz Paul EN2020RBell 206B · S/N 3599Ophthalmology Transport IncN2234KLuscombe 8A · S/N 4961Built 1947 · Magnuson Lloyd WN2239KLuscombe 8A · S/N 4966Built 1947 · Magnuson Lloyd NN23011Luscombe 8A · S/N 934Magnuson Lloyd WN245SWBeech A36 · S/N E-2018Built 1982 · Crosswinds LLCN28864Luscombe 8A · S/N 1606Built 1940 · Magnuson Lloyd WN295BLTL Ultralight Sro STING TRAINER · S/N TLUSA106Built 2005 · Haynes Gregory PN342DSDiamond Aircraft Ind DA 40 · S/N 40042Haynes Gregory PN360AHRobinson Helicopter R44 II · S/N 12594Magnuson Lloyd WN3783BHylio AG-130 · S/N 050235Pr Farms LLCN393WPWesley D Perkins CCX-2300 · S/N CCX-2300-0105Built 2024 · Visual Crop LLCN48701Ryan Aeronautical ST3KR · S/N 2101Built 1942 · Magnuson Lloyd WN5220MCessna 152 · S/N 15284506Built 1980 · Cummings BrianN5812XCessna 310F · S/N 310-0112Built 1961 · All-Bid IncN6554GCessna 150L · S/N 15072054All Bid IncN6983BPiper PA-18A 150 · S/N 18-5105Wiltz Paul EN71261Luscombe 8A · S/N 2688Built 1946 · Magnuson Lloyd WN7681MDonald L Magnuson MUSTANG 2 · S/N M-2-2392Hayes Lance GN7700DBates Mr/Kincaid JW LJ4 CUB · S/N 13952Tomlinson Allen TN773PEPilatus PC-12/47E · S/N 1773Built 2018 · Progressive Tractor Leasing Co LLCN7898XBell 206-L4 · S/N 52299Built 2004 · Rigid Aviation LLCN8029ZGilbert Jeff A BUCK 2.5 · S/N 001Built 2003 · Hayes Lance GarettN85455Champion AERONCA 7AC · S/N 7AC-4195Built 1946 · Guidroz Brad F
Back to Opelousas, LA