Skip to content

Registered aircraft · 1,605

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 ('2071602', '2071603')
  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 ('2071602', '2071603')
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.

N3522VWyler Timothy C · Elm Springs, ARBuilt 1948 · S/N 14791 N3523VBaker Warren R · Vista, CABuilt 1948 · S/N 14792 N3525VEvans James I · Cheyenne, WYBuilt 1948 · S/N 14953 N3527VPoplar Grove Airmotive Inc · Poplar Grove, ILBuilt 1948 · S/N 14796 N3528VWallace Aviation Inc · Wallace, NEBuilt 1948 · S/N 14797 N3530VEllenberger Christopher B · Neenah, WIBuilt 1948 · S/N 14799 N3531VLunsford Ronald E · Marion, NCBuilt 1948 · S/N 14800 N3532VMause Kenneth M · Sunray, TXBuilt 1948 · S/N 14801 N3533VRegistration Pending · Brunswick, GARegistration pendingBuilt 1948 · S/N 14802 N3535VProulx Paul M · Marshall, VABuilt 1948 · S/N 14804 N3536VSantiago James J · Mountain Lakes, NJBuilt 1948 · S/N 14805 N3539VChad Goracke Farms Inc · Monroe, ORS/N 14811 N3544VNormandy Flyers Limited Inc · Middletown, DEBuilt 1978 · S/N 14816 N3551VPrince John C III · Frierson, LAS/N 14826 N3553VBellmann Carl W · Bryan, OHBuilt 1948 · S/N 14828 N3555VJohnson Peter L · Chico, CAS/N 14830 N3557VMonahan Mary D · Independence, MNBuilt 1948 · S/N 14832 N3559VArmstrong Scott T · Navasota, TXS/N 14834 N3565VStein Anthony J · Locust Grove, GABuilt 1948 · S/N 14892 N3572VRoberts Nigel C · The Plains, VABuilt 1948 · S/N 14955 N3574VRau Bradley W · Payette, IDS/N 14749 N3578V198 Main Street Aviation LLC · Sullivan, WIBuilt 1948 · S/N 14747 N3579VGreslin Michael D · Spearfish, SDBuilt 1948 · S/N 14748 N357HPAllred Thierry J · Casa Grande, AZBuilt 1946 · S/N 8836 N3581VBryan Les E · Evansville, INBuilt 1948 · S/N 14850 N3587VGarrett Flying Service Inc · Reeds Spring, MOS/N 14855 N3591VVeteran Aviation Services LLC · Frederick, MDBuilt 1948 · S/N 14859 N3595VRose James S · New Port Richey, FLBuilt 1948 · S/N 14863 N3596VPetko James G · Mishawaka, INBuilt 1948 · S/N 14864 N3600VTourt Jeffrey S · Yorkville, ILBuilt 1948 · S/N 14868 N3603VOwen Bertha C · Port Saint Lucie, FLBuilt 1948 · S/N 14871 N3604VLindsey Roy W · Quinlan, TXBuilt 1948 · S/N 14872 N3606VAimrich Enterprises Inc · Wilmington, DEBuilt 1948 · S/N 14874 N3609VSidney Aviation LLC · Sidney, NEBuilt 1948 · S/N 14877 N3612VBenjamin Scott T · Estherville, IABuilt 1948 · S/N 14880 N3613VMcwilliams Eric T · Medina, OHBuilt 1948 · S/N 14881 N3616VSemler Greg · Guthrie, OKBuilt 1948 · S/N 14884 N3618VPudik James N · Metamora, ILBuilt 1948 · S/N 14886 N3619VHardesty Jerry L · Terrebonne, ORBuilt 1948 · S/N 14887 N3624VWiens Patrick B · Houston, TXBuilt 1948 · S/N 14895 N3629VHeitz John · Manvel, TXBuilt 1948 · S/N 14900 N3631VFisher Air LLC · Cardington, OHBuilt 1948 · S/N 14902 N3633VPatrick Michael D · Port Saint Joe, FLBuilt 1948 · S/N 14904 N3636VMorgan Jarrett A · Amherst, WIBuilt 1948 · S/N 14907 N3640VSeaton Robert D · Seguin, TXBuilt 1948 · S/N 14911 N3645VBryan Joseph J · Gilbert, SCS/N 14916 N3646VThompson Randy L · Anderson, CABuilt 1948 · S/N 14917 N3648VNeary Russ P · Plympton, MABuilt 1948 · S/N 14919 N3651VEastern Stearman Inc Trustee · Leesburg, VABuilt 1948 · S/N 14922 N3653VPlane Fun Inc Tr Trustee · Snellville, GABuilt 1948 · S/N 14924

Back to Cessna 140