Skip to content

Fairchild 24R-46

Registered aircraft · 50

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

N18688Pfou Michael G · Princeton, MNBuilt 1939 · S/N W-101 N282FCClassic Toy Barn LLC · Central Islip, NYS/N R46261 N690FAParsons Donald L · Saint Peters, MOBuilt 1946 · S/N R46104 N77603Eastern Stearman Inc Trustee · Leesburg, VABuilt 1946 · S/N R46-303 N77611Denzler Theodore A · Friendswood, TXBuilt 1946 · S/N R46311 N77654Hettenbach Paul A · Carrollton, TXBuilt 1947 · S/N R46333 N77657Kahl William E · Syracuse, NYBuilt 1947 · S/N R46316 N77660Plane Fun Inc Tr Trustee · Snellville, GABuilt 1946 · S/N R46-360 N77661L & P Of Winona Inc · Winona, MNBuilt 1947 · S/N R46361 N77665Dougherty James W Jr · Arlington, TXBuilt 1947 · S/N R46365 N77671Ramos Richard E · Benicia, CABuilt 1946 · S/N R-46371 N77672Demmel Ross · Tumwater, WAS/N R-46372 N77686Harper Jack D · Jacksonville, FLS/N R46386 N77688Short David J · Warrensburg, MOBuilt 1947 · S/N R46388 N77691Hamilton Steven T · Carson City, NVBuilt 1947 · S/N R46391 N77695Kipnis Inc · Wadsworth, ILS/N R46336 N77696American Airpower Heritage Flying Museum · Dallas, TXBuilt 1947 · S/N R46337 N77698Perez Philip G · Fort Worth, TXBuilt 1947 · S/N R46398 N81204Stone Craig J · Renton, WABuilt 1946 · S/N R46-105 N81208Latimer Mark A · Roanoke, TXBuilt 1946 · S/N R46-109 N81210Fairchild Argus LLC · Evergreen, COBuilt 1946 · S/N R46-111 N81212Bartholomew Russell J · Albuquerque, NMBuilt 1946 · S/N R46113 N81213Yanks Air Museum · Baldwin Park, CABuilt 1946 · S/N R46114 N81214Letourneau Jaffe B · Olympia, WABuilt 1946 · S/N R46-115 N81226Felda Flyers LLC · Felda, FLBuilt 1946 · S/N R46127 N81228Hagerstown Aviation Museum Inc · Hagerstown, MDBuilt 1946 · S/N R46-129 N81234Haggerty John J Jr · Skaneateles, NYBuilt 1946 · S/N R46-135 N81241Clemens Russell E · El Cajon, CABuilt 1946 · S/N R-46142 N81242Davis Susan J · Castroville, CABuilt 1946 · S/N R46143 N81243Martin Jonathan W · West Grove, PABuilt 1946 · S/N R46144 N81255Egmond Aircraft LLC · Lewes, DEBuilt 1946 · S/N R46155 N81270Modlin Clarence T Jr · Dickinson, TXBuilt 1946 · S/N R46170 N81276Dowdy John H · Union, WVBuilt 1946 · S/N R46176 N81284Registered aircraftS/N R-46184 N81285Richard D James · Groveland, FLBuilt 1946 · S/N R46185 N81295American Aviation II LLC · Peyton, COBuilt 1946 · S/N R46195 N81306Sale Reported · Seneca, SCSale reportedS/N R46206 N81311Eddie Adams · Senath, MOBuilt 1946 · S/N R46211 N81325Weeks Monte L · Somerset, WIBuilt 1946 · S/N R46225 N81326Camp Ted A · Williamson, GABuilt 1946 · S/N R46226 N81329Jenkins James L · Lake Stevens, WABuilt 1946 · S/N R46-229 N81330Shank Paul L · Gaithersburg, MDBuilt 1946 · S/N R-46230 N81331Linn Ronald D · Stanfield, ORBuilt 1946 · S/N R46231 N81334Handly William A · Arcola, MSBuilt 1946 · S/N R46234 N81348American Airpower Heritage Flying Museum · Dallas, TXBuilt 1946 · S/N R46-248 N81349Dyson Keith A · Port Townsend, WABuilt 1946 · S/N R46249 N81358Ferguson Cris · Livermore, CABuilt 1946 · S/N R46258 N81362Jones Kenneth M · Auburn, CABuilt 1946 · S/N R46262 N81363Alexander Larry A · Kosciusko, MSBuilt 1946 · S/N R46263 N987Carlsbad Raceway Corp · Hemet, CABuilt 1947 · S/N R46-389

Back to Fairchild 24R-46