Monroe, NC
Registered aircraft · 56
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 = 'NC' 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 = 'NC' 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.
N11086Champion 7ECA · S/N 7ECA103N1418EChampion 7AC · S/N 7AC-4981N144PWCessna 172G · S/N 17254019N1647JFirefly Balloons FIREFLY 8 · S/N F8-2020N16YZCirrus Design SR22T · S/N 2075N18DBBell 407 · S/N 53165N2055ECessna 172N · S/N 17271134N20997Cessna 172E · S/N 17251217N240MBCirrus Design SR22 · S/N 1880N241MBCirrus Design SR22 · S/N 0910N2501FChampion 7ECA · S/N 7ECA140N2528KLuscombe 8E · S/N 5255N264MBCirrus Design SR22 · S/N 10161N265MBCirrus Design SR22 · S/N 10163N284BSDJI AGRAS T40 · S/N 1581F574B226M001008CN284CLCirrus Design SR20 · S/N 11272N284ESDJI AGRAS T40 · S/N 1581F574B22740010ZEEN292XWBritish JET PROVOST T MK5 · S/N EEP/JP/956N3067CBeech K35 · S/N D-5731N326BSSingrey Harold E NIEUPORT 17 · S/N 1500N33631Piper PA-32-260 · S/N 32-7500026N35099Cessna 177B · S/N 17702205N3727JCessna 150G · S/N 15065027N3733RCessna 172H · S/N 17255533N377MMCessna 172H · S/N 17256133N37997Beech 77 · S/N WA-190N3809CBeech F90 · S/N LA-112N43164Piper PA-28-140 · S/N 28-7425340N433BVCirrus Design SR20 · S/N 10455N458LTRobinson Helicopter R44 II · S/N 14803N48016Ryan Aeronautical ST3KR · S/N 1492N524LPPipistrel D O O ALPHA TRAINER · S/N 1213 AT 912 LSAN532LPPipistrel D O O ALPHA TRAINER · S/N 1216 AT 912 LSAN5385JCessna 172N · S/N 17273775N540NCDJI AGRAS T40 · S/N 64TBK8U00100CGN5465KCessna 172P · S/N 17274131N5571QMooney M20C · S/N 2974N614RFFletcher Ray N RV-4 · S/N 2614N6270SCessna 150G · S/N 15067070N62BTRogers Bob J MUSTANG II · S/N M-II-1502N6699WHomsley J/Watson L STARDUSTER STARLET · S/N 200299WN674BACirrus Design SR20 · S/N 11140N74EBBond Elwood M SE-5A · S/N 02N7832UCessna 172F · S/N 17251832N8081LCessna 172H · S/N 17256281N810MJPiper PA-32-300 · S/N 32-7440082N8165QBeech A36 · S/N E-2592N84254Aeronca 7AC · S/N 7AC-2946N8457FPiper PA-32R-300 · S/N 32R-7780101N8538MBeech P35 · S/N D-7211
Back to Monroe, NC