Skip to content

Fairchild 24W-46

Registered aircraft · 53

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

N23VWomack Jeffrey · Jackson, LABuilt 1946 · S/N W46-134 N4263SRobbins III James E · Lakeland, TNBuilt 1946 · S/N W46299 N77602Leighton George E · Seattle, WABuilt 1946 · S/N W46302 N77605Grossl Cameron L · Georgetown, KYBuilt 1946 · S/N W46-305 N77607Potter Everett A P · Lansford, NDBuilt 1946 · S/N W46307 N77609Tall Timber Flying Service LLC · Kalispell, MTBuilt 1946 · S/N W46309 N77614K E F Enterprises Inc · Plymouth, MABuilt 1946 · S/N W46314 N77618Schulert Philip J · Lebanon, TNBuilt 1946 · S/N W46-318 N77630Barrong John M · Cottage Grove, ORBuilt 1946 · S/N W46330 N77638Santorelly R · Glen Saint Mary, FLS/N W46-338 N77655Buntings Grassroots Aviation LLC · Selbyville, DEBuilt 1947 · S/N W46355 N77656Ramos Richard E · Benicia, CABuilt 1947 · S/N W46356 N77659Patrick Matthew · Cincinnati, OHBuilt 1947 · S/N W46359 N77667Smith Happy E · Rogersville, TNBuilt 1947 · S/N W46367 N77681Grasso Vaughn L · Oak Hill, FLBuilt 1946 · S/N W46381 N77682Stoos Robert A · Lakeland, FLS/N W46382 N81201Avdeev Alexey · Purcellville, VABuilt 1946 · S/N W46102 N81206Fulwiler Daniel R · Green Bay, WIBuilt 1946 · S/N W46107 N81209Vecchiarelli Timothy J · Somers, CTBuilt 1946 · S/N W46110 N81216Rockys Flying Service LLC · Wilmington, DEBuilt 1946 · S/N W46117 N81222Keppen Charles J · Madison, SDBuilt 1946 · S/N W46123 N81229Cassen Mark E · Wilson, WYBuilt 1946 · S/N W46130 N81244Modlin Clarence T Jr · Dickinson, TXBuilt 1946 · S/N W46145 N81248Miller Alan D · Prescott Valley, AZBuilt 1946 · S/N W46149 N81258Barnhill Eric · Seneca, SCBuilt 1946 · S/N W-46158 N81261Schur David J · La Vernia, TXBuilt 1946 · S/N W46161 N81263Roussopoulos Gary Lee · Santa Cruz, CABuilt 1946 · S/N W-46163 N81264Wentworth Charles G Trustee · Paso Robles, CAS/N W46164 N81265Hedberg Jan P · Monmouth, ORBuilt 1946 · S/N W46165 N81271Mcintire Thomas Jay · Lancaster, PAS/N W46-171 N81275Thomson Kevin · Lake Tapps, WABuilt 1946 · S/N W46175 N81279C A S Aerobatic LLC · Carthage, MOBuilt 1946 · S/N W46179 N81288Registration Pending · Seneca, SCRegistration pendingBuilt 1946 · S/N W46215 N81290Milne Sales And Services LLC · Lake Geneva, WIS/N W46190 N81309Lubak Lawrencee · Chino Hills, CAS/N W46209 N81318Gilmore Mark S · Seneca, SCBuilt 1946 · S/N W46218 N81320Wentworth Charles G Trustee · Paso Robles, CAS/N W46220 N81324Continental Title Trust LLC · Wichita, KSS/N W46224 N81332Skillman Michael W · Brookshire, TXBuilt 1946 · S/N W-46232 N81333Great Lakes Aircraft LLC · Palmer Lake, COBuilt 1946 · S/N W46233 N81335M&Mzar LLC · Los Lunas, NMBuilt 1946 · S/N W46-235 N81340Etter Robert L · Tonopah, NVBuilt 1946 · S/N W46240 N81343Crestair Air LLC · Dover, DEBuilt 1946 · S/N W46243 N81346Vos Jared C · Cloverdale, CABuilt 1946 · S/N W46246 N81356Dickerson Michael W · Seattle, WAS/N W46256 N81369Liimatainen William J · Monroe, WIBuilt 1946 · S/N W46269 N81386Hoffman Edward C Jr · Tarpon Springs, FLBuilt 1946 · S/N W46286 N81390Plane Fun Inc Tr Trustee · Snellville, GAS/N W46290 N81393Elrod Brent W · Cashion, OKBuilt 1946 · S/N W46293 N81395Combat Air Museum Inc · Topeka, KSBuilt 1946 · S/N W46295

Back to Fairchild 24W-46