Covington, LA
Registered aircraft · 45
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 = 'COVINGTON' 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 = 'LA' AND g.registrant_city = 'COVINGTON' 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.
N10207Cessna 150L · S/N 15074819N10450Aeronca 7BCM · S/N 7BCM-97N108UCPiper PA-31T · S/N 31T-8020018N111EXCessna 172P · S/N 17275024N1391TPiper PA-32-300 · S/N 32-7240117N170SKCessna 172N · S/N 17273173N19434Monocoupe 90A · S/N A784N2099DCessna 172R · S/N 17281204N2106BLuscombe 8A · S/N 6533N221FTHawker Beechcraft B300 · S/N FL-688N22435Cessna 150H · S/N 15068279N228STCirrus Design SF50 · S/N 0471N2842DPiper PA-28-181 · S/N 28-7990488N300GTToups Gary S LEGACY 2000 · S/N L2K-172N33SDRobert S Detton DETTON8R · S/N 80678N3411QPiper PA-28-161 · S/N 28-7716155N355GRBeech H35 · S/N D-5328N3596YCessna 182F · S/N 18254496N3648CDJI MAVIC 3 FLY MORE CMB · S/N 1581F45TB21BJ1BE0391N374TMHigby Gary G KITFOX MODEL IV · S/N 1850N388MBDassault FALCON 7X · S/N 222N394RBAmerican Champion 8KCAB · S/N 837-99N41QCBeech 95-C55 · S/N TE-150N444MTAerotek PITTS S-2A · S/N 2079N4641QCessna 172M · S/N 17261733N5029EBellanca 7GCAA · S/N 367-78N5155LPiper PA-28-180 · S/N 28-4440N5484JCessna T310R · S/N 310R0282N5816TMooney M20J · S/N 24-1569N619JSSimmons Jim SKYBOLT · S/N 002N64278Cessna Claassen 305A(0-1A) · S/N 23204N660BACessna LC41-550FG · S/N 411056N694DBPiper PA-32-300 · S/N 32-7540087N8263ZPiper PA-28-236 · S/N 28-8111002N83911Aeronca 7AC · S/N 7AC-2594N8456PPiper PA-24-400 · S/N 26-31N870TDDJI PHANTOM 4 PRO OBSIDI · S/N 189CEAUN870WTBellanca 8KCAB · S/N 151-74N9081GCessna 182N · S/N 18260621N928PCCessna LC41-550FG · S/N 411003N9349XCessna 182E · S/N 18253749N9407WPiper PA-28-235 · S/N 28-11114N945TRCirrus Design SR22 · S/N 2169N95HDDierks Herman Dietrich JR RV-4 · S/N 1255N9859WPiper PA-28-140 · S/N 28-23374
Back to Covington, LA