Skip to content

Classic WACO YMF

Registered aircraft · 46

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

N100GJEdminston Brandon L · Murray, KYBuilt 1995 · S/N F5C-065 N13WHLonon Michael E · Yuba City, CABuilt 1988 · S/N F5-013 N14081Mills Charles K · Hernando, FLBuilt 1987 · S/N F5-009 N14770Vintage Tailwheel LLC · Ocala, FLBuilt 1991 · S/N F5C043 N17XKMaine Coastal Flight Center Inc · Bangor, MES/N F5C-048 N1935BKrushnir Borys G · Tamuning, GUBuilt 1985 · S/N F5-001 N196RBSnap N Roll Ltd · Wilmington, DEBuilt 1996 · S/N F5C-071 N21WFTimeless Aviation LLC · Cedar Lake, INBuilt 1989 · S/N F5-021 N2269VFlying Aces Aero-Fleet Inc · Guyton, GAS/N F5028 N226HSObrien Jerry M · Lake Forest, ILBuilt 1989 · S/N F5-026 N250YMN250ym LLC · Melbourne, FLBuilt 1994 · S/N F5C-059 N31BNAbbott Aircraft Sales And Service LLC · Holts Summit, MOBuilt 1996 · S/N F5C-067 N333GDSs & C Aviation LLC · North Fort Myers, FLBuilt 1991 · S/N F5041 N34SKBig Q Aviation Corp · Midlothian, TXBuilt 1990 · S/N F5-034 N35HHPlane Fun Inc Tr (Trustee) · Snellville, GABuilt 1988 · S/N F5-017 N369ASCape Aerial Tours Inc DBA · Chatham, MABuilt 1992 · S/N F5C-046 N369BPGholizadeh Neta L Successor Trustee · Tehachapi, CABuilt 1987 · S/N F5-005 N40112King Aviation Enterprises LLC · Sarasota, FLBuilt 1989 · S/N F5-025 N40116Cloud Dancer Inc · Berlin, MDS/N F5-024 N40121Freebird Flight Service LLC · Lancaster, SCBuilt 1990 · S/N F5029 N40135Lucke Stewart · Minot, NDBuilt 1991 · S/N F5-035 N43000Scallywag Air LLC · Galveston, TXBuilt 1994 · S/N F5C-060 N43016Classic Barnstormers LLC · Campbellsville, KYBuilt 1993 · S/N F5C051 N43041Aircraft Fidelity Corp Trustee · Dover, DES/N F5C-054 N43064Kloker Aviation · Owasso, OKBuilt 1994 · S/N F5C-062 N513RSConroy Patrick · Frankston, TXBuilt 1992 · S/N F5C-049 N527MNAir Adventure Inc · Cicero, INBuilt 1988 · S/N F5-012 N54SHCloud Dancer Inc · Berlin, MDBuilt 1988 · S/N F5-011 N569WKhn Air LLC · Carmel, CABuilt 1996 · S/N F5C-069 N575TLEvening Zephyr LLC · Fort Wayne, INBuilt 1991 · S/N F5C040 N5YMBaystormers Ltd · Lewes, DEBuilt 1992 · S/N F5036 N61MLBarr Richard Guy · Carlisle, PABuilt 1994 · S/N F5C-061 N62XXMelhoff Richard L · Hubbard, ORS/N F5-027 N66PPFordice Daniel K III · Vicksburg, MSBuilt 1995 · S/N F5C-066 N685AFShallow David M · Salmon, IDBuilt 1991 · S/N F5C-044 N723SRHuff Air LLC · Reno, NVBuilt 1996 · S/N F5C-070 N789WCFlying Gato LLC · The Woodlands, TXBuilt 1997 · S/N F5C078 N7PBrewer George F II · Colorado Springs, COBuilt 1990 · S/N F5-031 N88JPN88jp Corp Trustee · Wilmington, DEBuilt 1995 · S/N F5C-063 N88YNo Regerts Inc · Middletown, DES/N F5-014 N89BVictoria'S Wings LLC · Melbourne, FLBuilt 1987 · S/N F5-006 N92WPCentex Flying Service LLC · Bangs, TXBuilt 1991 · S/N F5C042 N940SNess D Todd · Lyons, MIBuilt 1994 · S/N F5C-057 N954JDMccaul Benjamin · San Luis Obispo, CAS/N F5-010 N95JDClassic Wings LLC · Ballwin, MOBuilt 1994 · S/N F5C-058 N96TGeorge Mike J · Springfield, ILS/N F5C-052

Back to Classic WACO YMF