Skip to content

North American SNJ-4

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

N103LTAmerican Airpower Heritage Flying Museum · Dallas, TXBuilt 1943 · S/N 88-12097 N119DPWarbird Adventures LLC · Casa Grande, AZBuilt 1942 · S/N 88-10185 N26808Historic Wings LLC · Whitehouse Station, NJBuilt 1956 · S/N 26808 N27585American Airpower Heritage Fly Musm · Dallas, TXBuilt 1943 · S/N 88-13041 N27775Strahan Sam · San Angelo, TXBuilt 1943 · S/N 88-13391 N299FMMckendree Leslie A · Canton, GABuilt 1959 · S/N 88-12533 N33CCEvergreen Avn Space Museum And Captain Michael · Mcminnville, ORS/N 88-13466 N4140AKinnamon Kyle Trustee · Eden, MDBuilt 1947 · S/N 88-13625 N4419TBabcock Greg J · Wapato, WAS/N 26904 N45WANorth American Warbirds Inc · Wilmington, DEBuilt 1942 · S/N 8811850 N495MKKilo Kilo LLC · Wausau, WIBuilt 1943 · S/N 88-13132 N51428Mach 25 Aviation LLC · Hudson, WIBuilt 1957 · S/N 88-13891 N5287NPlourde Steven J · Woodstock, ILBuilt 1946 · S/N 88-9551 N540GMMartin Guy E · Brookings, ORBuilt 1944 · S/N 88-9141 N6171ALt Development Group LLC · Watford City, NDBuilt 1942 · S/N 88-13585 N6171CHenry Gary R · Refugio, TXS/N 88-13568 N6411DAmerican Airpower Heritage Flying Mu · Dallas, TXBuilt 1942 · S/N 88-10117 N6420DSmall Aviation No 2 LLC · Villa Rica, GAS/N 88-13374 N6421DBibber Eugene A · Anchorage, AKS/N 88-13386 N6422DSyf LLC · Okmulgee, OKBuilt 1942 · S/N 88-13478 N6423DTennessee Flying Machines LLC · Nashville, TNBuilt 1941 · S/N 88-13519 N6427DEagle Eye Aviation LLC · Meridian, IDBuilt 1957 · S/N 88-14317 N665RYKubecka Jana · Edna, TXBuilt 1942 · S/N 8811340 N67003Mid-Atlantic Aircraft Leasing LLC · Wilmington, DEBuilt 1942 · S/N 88-13166 N694USEchelon Group Aviation LLC · Boise, IDS/N 88-13627 N7011CBurchinal Skyler C · Brookston, TXS/N 8813805 N7024CAmerican Airpower Heritage Flying Museum · Dallas, TXBuilt 1943 · S/N 88-13517 N7034CLewis Flying & Maintenance Service Inc · Morse, LABuilt 1957 · S/N 88-13640 N7038CMonkey Air LLC · Roseville, CABuilt 1957 · S/N 88-12932 N7058CVaughn Thomas N · Tulia, TXS/N 27352 N7062CJapanese Bomber LLC · Atlanta, GABuilt 1943 · S/N 88-13171 N7070CDel Ag Aero LLC · Milton, DES/N 88-13164 N7077CWells Stewart P · Gold Run, CABuilt 1939 · S/N 88-13376 N7083CGross Flying Service Inc · Larned, KSS/N 88-14047 N7090CBormes John M · Aberdeen, SDS/N 88-13370 N7093CCoffman Robert P · Bigfork, MTS/N 88-10271 N709AWHooey Kevin M · Corning, NYS/N 51643 N712AWHistoric Aeroplane Works Inc · Huntington, INS/N 27222 N714AWN714aw LLC · Granite Falls, MNBuilt 1943 · S/N 27234 N7404CSanders Racing Inc · Jasper, ALBuilt 1943 · S/N 88-14124 N7406CHayden Aviation LLC · Rhome, TXBuilt 1943 · S/N 88-14342 N7412CHevle Aviation LLC · Bakersfield, CABuilt 1956 · S/N 88-12640 N7437CEngler Eric M DBA · Cass City, MIS/N 88-13067 N75964Nightingale William T · Alta Loma, CABuilt 1943 · S/N 88-9830 N763VRandel Vernon E · Erie, COBuilt 1957 · S/N 88-13763 N7646SCremair Inc Trustee · Wilmington, DES/N 8813050 N7692ZAero Properties II LLC · Fontana, CABuilt 1942 · S/N 889831 N86WWCondor Squadron Officers & Airmens Assoc Inc · Van Nuys, CABuilt 1956 · S/N 88-12291 N934JTTobul James R · Jackson, WYBuilt 1942 · S/N 88-12858 N9589CSooner Warbirds LLC · Norman, OKBuilt 1942 · S/N 889351

Back to North American SNJ-4