Skip to content

Registered aircraft · 16

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 ('0590028', '05903A7')
  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 ('0590028', '05903A7')
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.

N155JTWelch Robert A · Greenfield, INS/N 1292948 N1890CJohnson Troy A · Greenfield, MOS/N SB001 N217CVVarada Carlos R · Toa Alta, PRBuilt 1995 · S/N 06950614 N2481SUnderwood Ricky I · New Market, ALBuilt 1991 · S/N 0491071 N2649BGraham Austin J · Belton, TXS/N 0692236 N280RJJones Douglas K · Lipan, TXBuilt 1994 · S/N 09940518-1 N417WBReuter Richard J · Windsor, VAS/N 0295561 N4483AMidtgaard Michael A · Mason City, IABuilt 1994 · S/N 049607101 N474LLaney Rebecca A · New London, NCS/N 0592215 N5092PLimbacher Richard A · Stone Creek, OHS/N 0395567 N544BCMolano Gonzalo A · Marana, AZBuilt 1993 · S/N 1092297 N61307Press Richard · San Bernardino, CABuilt 1993 · S/N 0293375 N669BSBillman David E · Grinnell, IABuilt 1998 · S/N 1004692 N70193Mota Juan R · San Bernardino, CABuilt 1991 · S/N 1290051 N75102Buckwinkler Michael D · Sheridan, ILBuilt 1997 · S/N 0594499 N9341RBaldwin Thomas A · Puyallup, WABuilt 1992 · S/N 1092305

Back to Rans S12