West Ossipee, NH
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 = 'NH' AND g.registrant_city = 'WEST OSSIPEE' 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 = 'NH' AND g.registrant_city = 'WEST OSSIPEE' 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.
N10034Maule MX-7-160 · S/N 19045CN101TMLavoie Michael T LAVOIE 77K24G (AX-7) · S/N 002N104DECessna A185F · S/N 18504009N10UKMichael T Lavoie 56K12G (AX-6) · S/N 006N111HALavoie Mt/Lavoie TL 40K16GAX5 · S/N 005N116TWBeech V35B · S/N D-9529N131PHMaule MX-7-180A · S/N 20014CN13462Stinson JR. SR · S/N 8715N1578QCessna 150L · S/N 15072878N17307Cessna 305A · S/N 22041N1909CCessna 170B · S/N 26054N2073XAviat A-1B · S/N 2073N22204Piper PA-28-181 · S/N 28-7990071N229RVOrndorff G E/Orndorff R S RV6A · S/N 22029-RV6AN230BCBurgy John R RV-4 · S/N 1973N24273Flightstar FLIGHTSTAR II SC · S/N 001N2585Murle Williams KITFOX SERIES 7 · S/N 70507085N26DMRolladen-Schneider OHG LS1-F · S/N 437N3100YCessna 182E · S/N 18254100N327TPiper PA-18 · S/N 18-2441N3520ZPiper PA-22-150 · S/N 22-7420N35675Cessna 172I · S/N 17256900N38362Piper J3L-65 · S/N 4857N4135YBellanca 7GCBC · S/N 953-76N4405MMains Donald L PIETENPOL AIRCAMPER · S/N DLM01N48KCCessna 182B · S/N 52056N49778Boeing A75N1(PT17) · S/N 75-3009N50555Cessna 150J · S/N 15069396N50832Cessna 150J · S/N 15069584N5104CI.C.A.-Brasov IS-28B2 · S/N 70N5328NBoeing E75 · S/N 75-5894N5339SPiper PA-28-140 · S/N 28-26932N5441RCessna 172F · S/N 17252991N55VBBeech E-55 · S/N TE-1072N56HZLavoie Mt/Lavoie TL 56K12G · S/N 004N59252Boeing A75N1(PT17) · S/N 75-454N601WHHaseman William F ZENAIR CH 601XL · S/N 6-9341N61980Champion 7EC · S/N 7EC-703N6271MStinson 108-3 · S/N 108-4271N63145Cessna 180K · S/N 18052833N6337WPiper PA-28-140 · S/N 28-20394N635CACentrair 101A · S/N 101A0119N65TYCirrus Design SR22 · S/N 1452N6748TCessna 310D · S/N 39048N678TMLavoie Michael T LAVOIE 56K12G · S/N 001First renewal noticeN70828Piper J3C-65 · S/N 17844N720SBCessna 337A · S/N 337-0407N724KSteimmetz SUPER PARASOL · S/N 25N72570Cessna 140 · S/N 9740N737LZCessna 172N · S/N 17269513
Back to West Ossipee, NH