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 ('1461202')
  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 ('1461202')
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.

N1499TAirborne Adventures Inc · Kirkville, NYBuilt 1930 · S/N 300 N1PBrookway Aviation LLC · Brookhaven, MSS/N 325 N240HWingnut Inc · Wilmington, DEBuilt 1929 · S/N 108 N286HKasper Richard J · Swanzey, NHBuilt 1929 · S/N 119 N288HTexas Barnstorming Museum · Hallettsville, TXBuilt 1929 · S/N 121 N331KSchrock Clifford B · Portland, ORBuilt 1929 · S/N 45 N352MHutchings Mathew J · Camano Island, WABuilt 1930 · S/N 252 N403KNiemyjski Trevor Gregory · Union Grove, WIS/N 126 N409KVintage Props LLC · Iowa City, IABuilt 1929 · S/N 132 N431KElliott John David · Bethesda, MDBuilt 1929 · S/N 154 N436KReimer Ronald F · Borden, INBuilt 1929 · S/N 159 N447KGirdley Robert M · Mooresville, INS/N 170 N448KEnglund Ronald E · Springfield, ORBuilt 1929 · S/N 171 N606MPowell Larry C · Fresno, CABuilt 1929 · S/N 182 N608MTerman Jerry · Bodega Bay, CABuilt 1929 · S/N 184 N610MFlying H 16 Inc · Agoura Hills, CAS/N 186 N616MYenser David G · Kutztown, PABuilt 1929 · S/N 192 N617FWentworth Charles G - Trustee · Paso Robles, CABuilt 1929 · S/N 193 N618MDiedrich Steve A · Sandpoint, IDBuilt 1929 · S/N 194 N620RJohnson Fred R · Nappanee, INBuilt 1930 · S/N 196 N678MTreichler Peter · East Aurora, NYBuilt 1930 · S/N 226 N691MHolmes Steve A · Yellville, ARBuilt 1930 · S/N 241 N699MSommerfeld Paul S · Saint Charles, ILBuilt 1930 · S/N 249 N748VBenkert Daniel D · Rapid City, SDBuilt 1930 · S/N 333 N764VPemberton Addison J · Spokane, WAS/N 332 N767VEnglund Ronald E · Springfield, ORS/N 348 N8648Machamer John K · Gettysburg, PABuilt 1929 · S/N 61 N8687Donley Ronald L · Mountain Center, CABuilt 1929 · S/N 74

Back to Fleet 2