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.

N99514Workman James E · Zanesville, OHBuilt 1946 · S/N 2137 N99518Coats Christopher R · Vinita, OKBuilt 1946 · S/N 2141 N99520Graham William T · Gilroy, CABuilt 1946 · S/N 2143 N99529Allen John R III · Denton, MDBuilt 1946 · S/N 2152 N99530Hibler Kenith R · Newcastle, OKBuilt 1946 · S/N 2153 N99539Peppas George D Jr · Fort Wayne, INS/N 2162 N99561Harvell Randall W · Manteno, ILBuilt 1946 · S/N 2184 N99564Spiegel Darren J · Chicago, ILBuilt 1946 · S/N 2187 N99568Lloyd Ernest W III · Morrison, COBuilt 1946 · S/N 2191 N99591Olson Bruce I · Osceola, WIBuilt 1946 · S/N 2214 N99592Gregory Vernon L · Swansea, SCS/N 2215 N99596Miller Steve L · Naperville, ILBuilt 1946 · S/N 2219 N99600Jacobs Paul M Trustee · Hernando, MSS/N 2223 N99601Burch Genevieve · Phoenix, AZBuilt 1946 · S/N 2224 N99618Lull William G · Ramona, CABuilt 1946 · S/N 2241 N99633Huschle Micheal D · Hitterdal, MNBuilt 1946 · S/N 2256 N99643Bernstein Matthew D · Charleston, SCS/N 2266 N99648Morris Steven R · East Waterboro, MEBuilt 1946 · S/N 2271 N99649Taylor Edward J · Cedar Hill, TXBuilt 1946 · S/N 2272 N99657Newbury Dennis M II · Brea, CABuilt 1946 · S/N 2280 N99666Lemenager Mark A · Ashkum, ILBuilt 1946 · S/N 2289 N99671Howell Kenneth A · Long Beach, CABuilt 1946 · S/N 2294 N99674Haley Billie Jo · San Martin, CABuilt 1946 · S/N 2297 N99680Eaa Chapter 1590 Inc · Morrilton, ARBuilt 1946 · S/N 2303 N99684Gregory Vernon L · Swansea, SCBuilt 1946 · S/N 2307 N99685Greany Ralph · Ramona, CABuilt 1946 · S/N 2308 N99686Cullen Thomas E · Wakeman, OHBuilt 1946 · S/N 2309 N99701Davenport Jimmy J · Hayesville, NCBuilt 1946 · S/N 2324 N99703Treece Charles M · Morristown, TNFirst renewal noticeBuilt 1946 · S/N 2326 N99707Henk Edward W · Pine River, MNBuilt 1947 · S/N 2330 N99714Scroggins James R · Hollywood, FLBuilt 1946 · S/N 2337 N99716Gregory Vernon L · Swansea, SCBuilt 1946 · S/N 2339 N99720Morrison Donald H · Saint Cloud, FLS/N 2343 N99727Scott Bixler Edwin · Rising Fawn, GABuilt 1946 · S/N 2350 N99729Arndt Eric A · Jacksonville, FLBuilt 1946 · S/N 2352 N99739Herzog Eric M · New Waverly, TXS/N 2362 N99753Holliday Robert W · Tucson, AZBuilt 1946 · S/N 2376 N99757Walter Daniel E · Palmyra, PABuilt 1946 · S/N 2380 N99768Loveless Aaron Lee · Castroville, CABuilt 1946 · S/N 2391 N99778Downs Milo W · Lake Benton, MNBuilt 1946 · S/N 2401 N99780Toledo City School District · Swanton, OHBuilt 1946 · S/N 2403 N99790Rush Francis N · Rayne, LABuilt 1946 · S/N 2413 N99796Smith David L · Bellevue, NES/N 2419 N99807Hamilton Raymond W Trustee · Chillicothe, MOBuilt 1946 · S/N 2430 N99808Godbold Joshua M · Perdido Beach, ALS/N 2431 N99812Butts Thomas E · Nicholls, GABuilt 1946 · S/N 2435 N99816Sale Reported · Oklahoma City, OKSale reportedBuilt 1946 · S/N 2439 N99820Gregory Vernon L · Swansea, SCBuilt 1946 · S/N 2443 N99825Graham James L · Columbus, OHBuilt 1946 · S/N 2448 N99840Zmrzel David J · Port Saint Lucie, FLBuilt 1946 · S/N 2463

Back to Ercoupe 415-C