Registered aircraft · 41

Registered to this exact name, as owner or co-owner. Owners who share a name are listed together; other spellings aren’t included.

Query with SQL

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_name = 'SAMARITANS PURSE' OR list_contains(g.other_registrant_names, 'SAMARITANS PURSE') ORDER BY g.n_number

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_name = 'SAMARITANS PURSE' OR list_contains(g.other_registrant_names, 'SAMARITANS PURSE')
  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_name = 'SAMARITANS PURSE' OR list_contains(g.other_registrant_names, 'SAMARITANS PURSE')
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.

N130ZZDJI AIR 3 · S/N 1581F6N8C237J003225HBoone, NC N197SPDJI MAVIC 2 PRO · S/N 163DFBM0019913Boone, NC N217SPKodiak KODIAK 200 · S/N K2-0012Built 2024 · Boone, NC N218SPDJI MAVIC 2 PRO · S/N 163CG9VR0A2R26Boone, NC N228SPBell Helicopter Textron Canada 412EP · S/N 36548Built 2010 · Boone, NC N230YJDJI DJMAVIC3CDO · S/N 1581F67PB22BB00302SGBoone, NC N23BGDJI MINI 2 · S/N 3Q4CHAG3B3574HBoone, NC N296HSDJI MAVIC 3 CINE · S/N 1581F4QZ7243100EC1HEBoone, NC N300SPHawker Beechcraft B300C · S/N FM-26Boone, NC N3225YCessna 182E · S/N 18254225Boone, NC N34BGDJI MINI 2 · S/N 3Q4CHAF2B353YYBoone, NC N350SPHawker Beechcraft B300 · S/N FL-841Built 2013 · North Wilkesboro, NC N361ZADJI AVATA PRO · S/N 1581F4QWB229300303WUBoone, NC N365LSDJI MAVIC 3 PRO · S/N 1581F67QE23CC00A0089Boone, NC N37BGDJI MINI 2 · S/N 3Q4CHA63B33M22Boone, NC N399SPBell Textron Canada 407 · S/N 56373Built 2023 · Boone, NC N408SPTextron 408 · S/N 408-0034Built 2024 · Boone, NC N426SPTextron 408 · S/N 408-0071Built 2026 · Boone, NC N43SPDehavilland DHC-3 · S/N 140Built 1956 · Boone, NC N465SPQuest KODIAK 100 · S/N 100-0006Built 2008 · Boone, NC N466SPQuest KODIAK 100 · S/N 100-0015Boone, NC N467SPDouglas DC3 · S/N 32948Built 1945 · Boone, NC N499SPConstrucciones Aeronauticas CASA-212-200 · S/N 263Built 1982 · Boone, NC N545ESDJI AIR 3S · S/N 1581F895C25A5007JJRCBoone, NC N5530SDJI AIR 3S · S/N 1581F895C25A5007JJKKBoone, NC N583YMDJI MAVIC 3 FLY MORE CMB · S/N 1581F45TB21AW1AE01RQBoone, NC N5927ACessna 172 · S/N 28527Boone, NC N6688HCessna A185F · S/N 18503335Boone, NC N774SPCessna 208B · S/N 208B5030Built 2013 · Boone, NC N813NPDJI MAVIC PRO · S/N 08QDDCL01201VPBoone, NC N831SPCASA 212-CC · S/N 193Built 1982 · Boone, NC N842HPDJI MAVIC PRO · S/N 08QUEAXP0102XPBoone, NC N861QPDJI MAVIC 2 PRO · S/N F1051906260564Boone, NC N867TPDJI MAVIC 2 PRO · S/N 163DFAS001N114Boone, NC N867USDJI MAVIC 2 PRO · S/N 163DFAQ0013VW0Boone, NC N874SPBeech B200 · S/N BB-874Built 1981 · Boone, NC N883SPCessna 208B · S/N 208B0887Built 2001 · Boone, NC N906KKDJI AIR 3 · S/N 1581F6N8C2387003371PBoone, NC N907KKDJI AIR 3 · S/N 1581F6N8C238700334AVBoone, NC N946DCDJI MAVIC 3 · S/N 1581F45T7244100EDG3XBoone, NC N98SPTextron 208B · S/N 208B5409Built 2017 · Boone, NC

Back to Samaritans Purse