New Orleans, LA
Registered aircraft · 161
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 = 'NEW ORLEANS' 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 = 'NEW ORLEANS' 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.
N101PEGrumman G-44 · S/N 1386First renewal noticeN1068LLake LA-4-200 · S/N 661N10777Cessna 150L · S/N 15075030N1092ACessna 172S · S/N 172S10286N111DHonda HA-420 · S/N 42000246N1168TBeech E-55 · S/N TE-1045N120FMTextron 172S · S/N 172S13210N12ECBombardier BD-100-1A10 · S/N 20717N1327NCessna 172S · S/N 172S10380N145CHEurocopter Deutschland MBB-BK 117 C-2 · S/N 9228N1484UCessna 172M · S/N 17267151N162BLBeech A36 · S/N E-2263N1671DDavis James L LANCAIR 320 · S/N 1003-320-843N176AGPiper PA-28-181 · S/N 2881988N190SRCirrus Design SR22 · S/N 2641N194CDCirrus Design SR22 · S/N 1027N19TJTerrence Patrick Jacobs CHRISTEN EAGLE II · S/N TPJ 001N1BBGulfstream Aerospace G-V · S/N 660N1JKDassault FALCON 2000EX · S/N 130N205HCCessna 172S · S/N 172S10003N2103JPiper PA-28-236 · S/N 28-7911073N215RCBeech A23-24 · S/N MA-89N21HTPiper PA-38-112 · S/N 38-79A0806N21KFBeech 95-B55 (T42A) · S/N TC-1926N2209PPiper PA-23-250 · S/N 27-3788N220AUPiper PA-44-180 · S/N 4496617N22GJPiper PA-32-301 · S/N 32-8006026N2411NCessna 140 · S/N 12660N241PFCessna 150L · S/N 15075274First renewal noticeN242AUTextron 172S · S/N 172S13204N243AUTextron 172S · S/N 172S13223N244AUTextron 172S · S/N 172S13224N245AUTextron 172S · S/N 172S13226N2473ZCessna 172S · S/N 172S10082N247AUTextron 172S · S/N 172S13264N250AUTextron 172S · S/N 172S13265N251AUTextron 172S · S/N 172S13262N25PDPiper PA-34-220T · S/N 3448050N268FMTextron 172S · S/N 172S13268N271AGPiper PA-28-181 · S/N 2881989N2739UCessna 172D · S/N 17250339N275SBDiamond Aircraft Ind DA 40 NG · S/N 40.NC137N280RDDehavilland DHC-1B-2-S3 · S/N 146-184N2871LPiper PA-34-200T · S/N 34-7970300N315TLFlights Of Fancy STREAM · S/N 24 STR 15N3207ECessna 172N · S/N 17271468N323KMHawker Beechcraft 390 · S/N RB-270N325LAPiper PA-44-180 · S/N 4496487N33302Piper PA-32-300 · S/N 32-7540092N334ECBell Textron Canada 429 · S/N 57540
Back to New Orleans, LA