Raleigh, NC
Registered aircraft · 351
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 = 'RALEIGH' 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 = 'RALEIGH' 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.
N100XLRolladen-Schneider LS-3 · S/N 3401N103NCCessna 182S · S/N 18280647N1083JStinson 108-3 · S/N 108-4776N10DEBellanca 17-31A · S/N 73-32-108N118WPDJI INSPIRE 1 · S/N W13DCB16020177N120AVTL Ultralight Sro STINGSPORT · S/N TLUSA120N120TKCirrus Design SR20 · S/N 2156N121FTPiper PA-28-161 · S/N 28-8216191N125DDavid Kenny KITFOX S7 SUPERSPORT · S/N KA222778560N130EADJI MINI 3 PRO · S/N 1581F4XFA22AFML7RP9HN1313DCessna 170A · S/N 19889N133CBPiper PA-28R-200 · S/N 28R-7435318N138CKCirrus Design SR22 · S/N 3492N13JGulfstream Aerospace GVI (G650ER) · S/N 6147N13XXBeech M35 · S/N D-6467N140MCRaytheon B300 · S/N FL-140N1416NPiper J3C-65 · S/N 22941N141RSMaule M-7-260 · S/N 26006CN142NGDiamond Aircraft Ind DA 42 NG · S/N 42.082N1433SCessna 172S · S/N 172S10684N144JDRobinson Helicopter R44 · S/N 0938N1518FFirefly Balloons FIREFLY 7-15 · S/N F7-2011N151ELBeech 200 · S/N BB-371N1538ABalloon Works FIREFLY 6B · S/N 10191N1572XPiper PA-28-151 · S/N 28-7515425N1712SCessna 182T · S/N 18281620N187CRCessna 750 · S/N 750-0119N190MCCessna 560 · S/N 560-0769N193PCessna 206H · S/N 20608307N197RPHaughton Purser SUPERSTOL · S/N JA290-0313N19955Cessna 172M · S/N 17260885N2011JCameron Balloons US M-34 · S/N 6515N201MCCessna 525B · S/N 525B-0141N2036TTomalesky Peter TOPCAT · S/N TC1N2036XHead Balloons AX8-105 · S/N 362N2044XCessna 182H · S/N 18256144N205KKMooney M20J · S/N 24-3054N20697Cessna 172M · S/N 17261496N2129YCessna 172D · S/N 17249629N213CFCirrus Design SR22 · S/N 8557N2196TPiper PA-28-180 · S/N 28-7205047N220CHCompagnie Daher TBM 700 · S/N 1380N222WMCirrus Design SR22T · S/N 9057N22593Cessna 182T · S/N 18281938N227CHSocata TBM 700 · S/N 334N228MESocata TBM 700 · S/N 49N2298WCessna 172S · S/N 172S9968N2320VPiper PA-38-112 · S/N 38-82A0040N2353DCessna 170B · S/N 20505N239TCCessna 560XL · S/N 560-5817
Back to Raleigh, NC