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.

N87299Registration Pending · Sacramento, CARegistration pending, pending cancellationS/N 472 N872BWMosman Thomas M · Kingsland, TXBuilt 1946 · S/N 443 N87304Mackie Kevin S · Longview, WABuilt 1946 · S/N 477 N87333Luft Aviation Inc · Wilmington, DEBuilt 1946 · S/N 506 N87335Thomas Stewart L · Watkinsville, GABuilt 1946 · S/N 508 N87344Luft Aviation Inc · Wilmington, DEBuilt 1946 · S/N 517 N87366Sanford Stephen R · Wichita, KSBuilt 1946 · S/N 539 N87372Killhour Gilson · Fernandina Beach, FLBuilt 1946 · S/N 545 N87373Kirkendall Richard S · Havre De Grace, MDBuilt 1946 · S/N 546 N87374Gregory Vernon L · Swansea, SCBuilt 1946 · S/N 547 N87375Registration Pending · Arlington Heights, ILRegistration pendingBuilt 1946 · S/N 548 N87379Scott Homer R Sr · Del City, OKBuilt 1946 · S/N 552 N87385Hurst Edward E · Southlake, TXS/N 558 N87391Specht Leo M · Towner, COS/N 564 N87398John A Clairmont · Turner, MEBuilt 1946 · S/N 571 N87413Parker Thomas J · Hillsboro, WIBuilt 1946 · S/N 586 N87414Sweitzer Michael C · Bruneau, IDBuilt 1946 · S/N 587 N87416Amann David Paul · Wesley Chapel, FLBuilt 1946 · S/N 589 N87424Porterfield Tom · Abernathy, TXBuilt 1946 · S/N 597 N87433Four Five Air LLC · Traverse City, MIBuilt 1946 · S/N 606 N87435Owen Nick F · Jacksboro, TXBuilt 1946 · S/N 608 N87448Myers Blane L · Browns Valley, CAS/N 621 N87EVIllinois Ercoupe Flyers LLC · Belleville, ILBuilt 1946 · S/N 958 N900FGCordle Christopher T · Howard, OHBuilt 1946 · S/N 2459 N919RMHall Melvin E · Ocoee, FLS/N 698 N9270YBrunettin Mark · Frierson, LAS/N 3442 N93302Gregory Vernon L · Swansea, SCBuilt 1946 · S/N 625 N93332Gregory Vernon L · Swansea, SCBuilt 1946 · S/N 655 N93334Dates Lauren C · Red Creek, NYBuilt 1946 · S/N 657 N93358Rankins Todd E · Mohawk, NYBuilt 1946 · S/N 681 N93389Lambert Brian L · Tahlequah, OKBuilt 1946 · S/N 712 N93394Black Ronald D · Valley Center, KSBuilt 1946 · S/N 717 N93395Hildebrandt Colin R · Neenah, WIBuilt 1946 · S/N 718 N933PSCuellar Trajan A · Fargo, NDBuilt 1946 · S/N 3319 N93405Newsom Robert V · Chandler, AZBuilt 1946 · S/N 728 N93413Dodson Robert L · Ottawa, KSBuilt 1946 · S/N 736 N93418Hougland David W · Rapid City, SDBuilt 1946 · S/N 741 N93420Tres Amigos Flying Club LLC · Redding, CABuilt 1946 · S/N 743 N93421Gregory Vernon L · Swansea, SCBuilt 1946 · S/N 744 N93427Doerfler Linda J · East Amherst, NYBuilt 1946 · S/N 750 N93439Thomas Hunter David · Riverton, ILBuilt 1946 · S/N 762 N93443Jefferts Erik W · Susanville, CAS/N 766 N93448Bevis Richard L · Middletown, OHBuilt 1946 · S/N 771 N93449N46p Inc · Fort Wayne, INBuilt 1946 · S/N 772 N93453Stevens Robert L · Ventura, CABuilt 1946 · S/N 776 N93464Lopez Stephen D · Hopatcong, NJBuilt 1946 · S/N 787 N93482Gilson David R · New Port Richey, FLBuilt 1946 · S/N 805 N93498Van Nieuwenhuyzen Wesley G · Fremont, MIBuilt 1946 · S/N 821 N93499Muise Leroy · Trenton, MEBuilt 1946 · S/N 822 N93501Gbur Robert E · East Liverpool, OHBuilt 1946 · S/N 824

Back to Ercoupe 415-C