Skip to content

M-Squared SPRINT 1000

Registered aircraft · 13

Aircraft of this model in the FAA registry, by N-number.

Query with SQL

duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, registrant_name, registrant_city, registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
  WHERE aircraft_model_code IN ('059025M', '05903RZ', '05903U1', '05903IT', '05902NB', '05904V1', '05903H2')
  ORDER BY 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 n_number, serial_number, year_manufactured, status, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN ('059025M', '05903RZ', '05903U1', '05903IT', '05902NB', '05904V1', '05903H2')
ORDER BY 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.

N101ULClay John L · Cambridge, MNBuilt 1999 · S/N 00517 N138ZXSmeltzer Paul C · Texarkana, ARBuilt 2006 · S/N 000582DT N2732AHafner Terrance W · Winter Haven, FLBuilt 2002 · S/N 000592 N2979AVannuil Jerry E · Holland, MIBuilt 2001 · S/N 000650 N297RHanley Mark S · Bristol, MEBuilt 2006 · S/N 711 N3503FYarbro Bruce Edwin · Poplar Bluff, MOBuilt 2006 · S/N 000710 N35108Smith Morris W · Lucedale, MSBuilt 2001 · S/N 000558 N3816AVance Steven M · Moss Point, MSS/N 000543 N4415GBryant Dennis G · Loganville, GABuilt 2001 · S/N 000 549 N576JMLowe Sandra K · Magnolia Springs, ALBuilt 2005 · S/N 707 N7420CGrooms Nick L · Drakesville, IABuilt 2001 · S/N 3096 N8054QFrank Richard E · Bozeman, MTBuilt 2007 · S/N 000539 N9525QSpear Andy · Bolivar, MOBuilt 2005 · S/N 000702

Back to M-Squared SPRINT 1000