Skip to content

Registered aircraft · 624

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

N99851Kimmel Jonathan R · Lebanon, PABuilt 1946 · S/N 2474 N99894Hard Alan N · North Aurora, ILFirst renewal noticeBuilt 1946 · S/N 2517 N99899Dicksion William D · Bremerton, WABuilt 1946 · S/N 2522 N99904Dickson James · Salida, COBuilt 1946 · S/N 2527 N99907Rentoumis Michael G · Altoona, FLBuilt 1946 · S/N 2530 N99908Ryan Thomas S · Greenfield, WIBuilt 1946 · S/N 2531 N99916Nuremberg Auto Service Inc · Nuremberg, PABuilt 1946 · S/N 2539 N99919Poliak Mark A Trustee · Carmel, INBuilt 1946 · S/N 2542 N99928Kinker Christopher C · Charlestown, INS/N 2551 N99929Radle Steven H · Baker City, ORBuilt 1946 · S/N 2552 N99932Taylor Alexander M · Inwood, WVBuilt 1946 · S/N 2555 N99934Specht Leo M · Towner, COS/N 2557 N99936Abell Eric E · Centerville, OHBuilt 1946 · S/N 2559 N99939Poliak Mark A Trustee · Carmel, INBuilt 1946 · S/N 2562 N99955Cox Kermit R · Sterling, ILBuilt 1946 · S/N 2578 N99956Chase 13 LLC · Wilmington, DES/N 2579 N99962Beck Richard S · Acworth, GABuilt 1946 · S/N 2585 N99969Mullen Andrew P · NassauNon-citizen corporation, flight hours not reportedBuilt 1946 · S/N 2592 N99982Gobold Joshua M · Perdido Beach, ALS/N 2605 N99984Wentz George W · Loganville, GABuilt 1946 · S/N 2607 N99985Betke Hendrik C · Wyoming, MIBuilt 1946 · S/N 2608 N99997Lail Alan C · Villa Rica, GABuilt 1946 · S/N 2620 N999ACLunnie Robert P · Thompson, NDS/N 2573 N9UPBella Charles · Chaparral, NMBuilt 1946 · S/N 2146

Back to Ercoupe 415-C