Skip to content

Registered aircraft · 28

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 ('05901ZR', '05901J7', '0590224', '05632VT')
  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 ('05901ZR', '05901J7', '0590224', '05632VT')
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.

N124ARHowland Alan Ross · Zachary, LABuilt 2001 · S/N 1B0058 N172ASPurtell Gordon J · Lisle, ILBuilt 2000 · S/N 1B0144 N2549EOlson V Don · Salmon, IDBuilt 2000 · S/N 1B0025 N2553LWalden Ron D · Dothan, ALS/N 2C0354RWB N2563LRichter Leon F · Afton, MNBuilt 2007 · S/N 001 N3172NKrause Dave A · Red Bud, ILBuilt 2003 · S/N 4C0544 N338DWWhite Darrell W · Spencer, INBuilt 2000 · S/N 1B0056 N363MJNolan Robert · Brownington, VTBuilt 2008 · S/N 1B0137 N397GDDeas Glen E · West Monroe, LABuilt 2002 · S/N 3C0397 N4397GMartin Charles L · Hinesville, GABuilt 2000 · S/N 1B0107 N4401GBerry Thomas W · O Fallon, MOBuilt 2002 · S/N 3C0493 N4462GTarvainen Craig D · Chassell, MIBuilt 2001 · S/N 2C0380 N4758TBarnes Cecil M · Fort Madison, IABuilt 2000 · S/N 1B0059 N4829EHarris John L · Alamogordo, NMBuilt 2000 · S/N 1B0112 N50313Manning Donald G Jr · Mishawaka, INS/N 1B0105 N5080PBrinkmann Farms Inc · Carlyle, ILBuilt 2002 · S/N 3C0519 N5140LShadoan Peter D · Sumter, SCBuilt 2007 · S/N 3C0409 N5171XFuller Charles · Fort Smith, ARS/N 1B0125 N56352Winkelman Danny L · North Bend, NEBuilt 2000 · S/N 1B0136 N6951TWilliams Keith · Jacksboro, TXS/N 3C0475 N7136MDebruin Katie A · Cleveland, WIBuilt 2004 · S/N 3C0438 N7176JLangley Gary W · Georgetown, INBuilt 2000 · S/N 1B0183 N7285CSnyder Molly M · Wernersville, PAS/N W123040PPC N75273Thomas Mark C · Stillwater, PAS/N 3C0411 N7587APritchard Wm E · Evart, MIS/N 1B0079 N92473Johnston David · Fort Myers, FLS/N 3C0419 N92897Mull Guy A Jr · Lake Toxaway, NCBuilt 2007 · S/N 1B0180 N9382FPatterson Mathew · Ellisville, MSBuilt 2008 · S/N 200308

Back to Destiny 2000