Elizabeth City, NC
Registered aircraft · 63
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 = 'ELIZABETH CITY' 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 = 'ELIZABETH CITY' 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.
N1019CMooney M20R · S/N 29-0271N127KWCessna 172S · S/N 172S9827N149RHHenning Ray C T-18 · S/N 149N1502ECessna 172S · S/N 172S9900N15255Cessna 172S · S/N 172S10455N158ZLBeech D-45 · S/N BG-344N1777RCessna R182 · S/N R18200555N177PPVans RV-12 · S/N 120014N1862John Harold Siemens RV-8 · S/N 81734N1915YMooney M20D · S/N 210N201LLMooney M20J · S/N 24-0246N20MVTextron 172S · S/N 172S12143N212JHMooney M20J · S/N 24-0625N2346WBeech A23A · S/N M-944N2525SAmerican Champion 8KCAB · S/N 1225-2025N2770FCessna 182J · S/N 18256870N285VNTextron 172S · S/N 172S12414N287CAviat A-1A · S/N 1460N2884RCessna 182K · S/N 18258484First renewal noticeN291ECTextron 172S · S/N 172S12646N299DCEngineering & Research 415-C · S/N 1250N3211BPiper PA-22-150 · S/N 22-2038N3242SCessna 182G · S/N 18255742N363BLCessna 172S · S/N 172S9741N39907Bellanca 17-30A · S/N 73-30553Sale reported, pending cancellationN4239QCessna 172L · S/N 17260139N439EBBrock Edward L CHALLENGER II · S/N CH20789B0439N47636Piper PA-28-161 · S/N 28-7816110N493ECAlti USA ALTI REACH · S/N AR001N501RVSaunders Robert Clinton RV9A · S/N 90305N5133Volmer VJ22 AMPHIBIAN · S/N 1010N54355Cessna 172P · S/N 17274960N574AGCSP Leasing MTO SPORT · S/N M01302N5763LMooney M20J · S/N 24-1470N5847WPiper PA-28-160 · S/N 28-2286N647SPCessna 172S · S/N 172S8054N658WAAnderson Walter Thomas RANS S-7 COURIER · S/N WTA1N676CBTextron 172S · S/N 172S12619N7041QCessna 172L · S/N 17260341N72386Cessna 140 · S/N 9572N738LADiamond Aircraft Ind DA 42 NG · S/N 42.N538N760MAPiper PA-32R-301 · S/N 3246160N7DGCessna 172N · S/N 17268586N8028GCessna 177RG · S/N 177RG0028N8134SPiper PA-34-200T · S/N 34-8070056N828PKTextron 172S · S/N 172S12596N8374PPiper PA-32-301 · S/N 32-8106057N8481NBeech E33 · S/N CD-1175N86MRCessna 182Q · S/N 18267299N8746KStinson 108-1 · S/N 108-1746
Back to Elizabeth City, NC