Apex, NC
Registered aircraft · 68
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 = 'APEX' 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 = 'APEX' 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.
N118EESchempp-Hirth VENTUS 2CM · S/N 55N11953Cessna 150L · S/N 15075731N1205GCessna 310Q · S/N 310Q1060N12902Cessna 172M · S/N 17262357N1379DCessna 170A · S/N 19955N139MECessna 172S · S/N 172S8423N13VCCox Vernon Lewis PA 18 · S/N 0002N1411PDJI AGRAS T40 · S/N 52LBK6K0010014N176LGCessna 172RG · S/N 172RG0074N17PJPilatus PC-24 · S/N 520N19007Thomas Dennis J RV-4 · S/N 2079N1919BBeech B19 · S/N MB-794N2003MPiper PA-28-181 · S/N 28-7890221N20399Cessna 172M · S/N 17261259N2129CCessna 172S · S/N 172S9436N2130NCessna 140 · S/N 12366N21FXHawker Beechcraft 4000 · S/N RC-62N243MDDues Marshall M VANS RV-6 · S/N 20665N250TPiper PA-18-105 SPECIAL · S/N 18-2364N250YBCirrus Design SF50 · S/N 0181N26HUAviat A-1C-180 · S/N 3461N28543Piper PA-28-236 · S/N 28-7911165N28933Piper PA-32-300 · S/N 32-7940123N28BXCirrus Design SR22 · S/N 10904N291KFCessna 172L · S/N 17260482N292KFCessna 172N · S/N 17268188N31VGRobinson Helicopter R22 BETA · S/N 3551N32497Boeing A75N1(PT17) · S/N 75-1423N345USMooney M20R · S/N 29-0403N34LSStangil D-201 SPORT WING · S/N 1N3550TCessna 172S · S/N 172S8893N35SXAndrews Wayne SONEX · S/N 0035N3638RPiper PA-28-180 · S/N 28-5735N369BFFreckman Bill VANS RV-4 · S/N 3660N376SPCessna 172S · S/N 172S9508N3933HMooney M20J · S/N 24-0981N3CFCirrus Design SR22 · S/N 10580N40CHHayes Charles L LANCAIR IV · S/N LIV-237N419SFCessna 172M · S/N 17262659N425DLCessna 172RG · S/N 172RG0143N43XTGulfstream Aerospace GIV-X (G450) · S/N 4009N4427HRobinson Helicopter R44 · S/N 0923N449DYPiper PA-28R-200 · S/N 28R7235200N4BECessna 210 · S/N 57332N524KCPiper PA32-301FT · S/N 3232030N555MNCirrus Design SR22 · S/N 0664N602ACLearjet 60 · S/N 141N7158DRobinson Helicopter R22 BETA · S/N 3721N723DACirrus Design SR20 · S/N 9593N733CFCessna 510 · S/N 510-0458
Back to Apex, NC