Metairie, LA
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 = 'LA' AND g.registrant_city = 'METAIRIE' 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 = 'METAIRIE' 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.
N101TFTextron 172S · S/N 172S12710N102USCostruzioni Aeronautiche Tecna P-MENTOR · S/N 1120/USN105WTFly Virginia Beach WETTRIKE · S/N 001N112LGPiper PA-28-181 · S/N 2881907N138UDCessna 172S · S/N 172S11487N139UDCessna 172S · S/N 172S11488N13HNTextron 172S · S/N 172S13255N140UDCessna 172S · S/N 172S11489N142UDCessna 172S · S/N 172S11490N1449CCessna 172S · S/N 172S9892N15ANTextron 172S · S/N 172S13258N182NSCessna 182L · S/N 18258888N184LGPiper PA-28-181 · S/N 2881908N18930Beech C24R · S/N MC-527N1895LBeech 58 · S/N TH-894N201MWMooney M20J · S/N 24-0247N20BQTextron 172S · S/N 172S13216N2105XTextron 172S · S/N 172S12585N210TDCostruzioni Aeronautiche Tecna P2010 TDI · S/N 145/USN214MNWeathers Christopher C VANS RV-7 · S/N 72265N22102Cessna 150H · S/N 15068063Registration pendingN223TXCirrus Design SR22 · S/N 2494N225SFTextron 172S · S/N 172S13441N22692Cessna 150H · S/N 15068452Registration pendingN23MFBeech 95-B55 (T42A) · S/N TC-1684N246SFTextron 172S · S/N 172S13442N248SFTextron 172S · S/N 172S13443N24BQTextron 172S · S/N 172S13217N251SFTextron 172S · S/N 172S13444N254SFTextron 172S · S/N 172S13401N256SFTextron 172S · S/N 172S13403N259SFTextron 172S · S/N 172S13404N25BQTextron 172S · S/N 172S13218N263SFTextron 172S · S/N 172S13406N264SFTextron 172S · S/N 172S13407N265SFTextron 172S · S/N 172S13409N26BQTextron 172S · S/N 172S13219N26LPTextron 172S · S/N 172S13252N277LGPiper PA-28-181 · S/N 2881909N278UACostruzioni Aeronautiche Tecna P2010 · S/N 278/USN287UACostruzioni Aeronautiche Tecna P2010 TDI · S/N 287/USN28MKTextron 172S · S/N 172S13269N28PKTextron 172S · S/N 172S13253N294RWTextron 172S · S/N 172S12898N308KFCostruzioni Aeronautiche Tecna P2010 · S/N 296/USN3132FPiper PA-32-300 · S/N 32-7440023N316DCTextron 172S · S/N 172S12899N328FATextron 172S · S/N 172S13220N346PACessna 525B · S/N 525B0391N3506TCessna 172S · S/N 172S8962
Back to Metairie, LA