Monroe, 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 = 'MONROE' 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 = 'MONROE' 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.
N100TWBeech B100 · S/N BE-51N10832Cessna 150L · S/N 15075072N1170UMooney M20K · S/N 25-0702N11NDSidders Neil C ACRO SPORT II · S/N 425N148PFPiper PA-34-200T · S/N 34-7970017N158TACessna LC41-550FG · S/N 411005N227FDCirrus Design SR22 · S/N 9113N2VWPritchard Larry R SONERAI II · S/N 773N3066UPiper PA-32R-301T · S/N 3257341N3383YCessna 182E · S/N 18254383N33863Piper PA-28R-200 · S/N 28R-7535208N341JDSkykits SAVANNAH VGW · S/N 08-11-51-788Registration pendingN343RLGilbert Jackie Wayne SR KIS TR-1 · S/N 70N3857EAeronca 7AC · S/N 7AC-7096Registration pending, pending cancellationN474BGGilbertson Keith G ZODIAC CH 601HDS · S/N 63628N48383Grumman Acft ENG Cor-Schweizer G-164A · S/N 1623N555SCCessna 182N · S/N 18260261N600RLCessna 182R · S/N 18268567N617JHDJI AGRAS T40 · S/N 1581F574B2387001009WN623PTPiper PA 46-350P · S/N 4636543N654MFCirrus Design SR22 · S/N 8739N668ZHawker Beechcraft 390 · S/N RB-247N6694KGrumman Acft ENG Cor-Schweizer G-164B · S/N 424BN6720QGrumman Acft ENG Cor-Schweizer G-164B · S/N 238BN6734UBeech 58TC · S/N TK-117N6891KGrumman Acft ENG Cor-Schweizer G-164B · S/N 515BN7034RPiper PA-28-140 · S/N 28-21731N709VMTextron 525B · S/N 525B0709Registration pendingN712RXCirrus Design SR22 · S/N 4902N726NGPilatus PC-12/47E · S/N 1726N7278CPiper PA-32R-300 · S/N 32R-7680044N728DWRaytheon C90A · S/N LJ-1713N734JSCessna 172N · S/N 17268895N7362GCessna 172K · S/N 17259062N741XGummere John D SONEX · S/N 0441N748CXCessna 525B · S/N 525B0005N759DSCessna 182Q · S/N 18265916N7809GCessna 172L · S/N 17259509N8353VChampion 7ECA · S/N 294N8375CPiper PA-32R-300 · S/N 32R-7680103N91464Cessna 180H · S/N 18052091N93339Cessna 152 · S/N 15285470N9539Beech 3NM · S/N CA241N95PJBeech 58 · S/N TH-1162N96594Cessna 182Q · S/N 18266772
Back to Monroe, LA