Skip to content

Registered aircraft · 897

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 ('8190104', '8190111')
  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 ('8190104', '8190111')
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.

N71342Oliva Samuel A · Lebanon, TNBuilt 1946 · S/N 2769 N71345Zawalski Mark G · Webster Groves, MOBuilt 1946 · S/N 2772 N71346Osmndson Thomas J · Kent, WABuilt 1946 · S/N 2773 N71352Hare Hayden H · Roanoke, ALBuilt 1946 · S/N 2779 N71353Sides Jerry Webster · Medina, TXBuilt 1946 · S/N 2780 N71356Glenn Larry W · Bunn, NCS/N 2783 N71363Registered aircraftBuilt 1946 · S/N 2790 N71364Collins Camden B · Millersport, OHBuilt 1946 · S/N 2791 N71365Atwell Christopher Allen · Leesburg, FLBuilt 1946 · S/N 2792 N71366Monteleone Gene R · Mount Vernon, TXBuilt 1946 · S/N 2793 N71372Lee Johnathan C · New Braunfels, TXBuilt 1946 · S/N 2799 N71373Wilson Mikel W · Picayune, MSBuilt 1946 · S/N 2800 N71379Lowry Wilson R · Leonardtown, MDBuilt 1946 · S/N 2806 N71381Windsock Capital LLC · Bertram, TXS/N 2808 N71385Scott Steve W · Antioch, CABuilt 1946 · S/N 2812 N71389Jacobs William O Jr · Holly Hill, FLS/N 2816 N71402Dierks Herman D Jr · Round Rock, TXBuilt 1946 · S/N 2829 N71406Tomlin Rayburn H · Burleson, TXBuilt 1946 · S/N 2833 N71407Kreikemeier Terry L · Garfield, WABuilt 1946 · S/N 2834 N71413Thompson Eric J · Tempe, AZBuilt 1946 · S/N 2840 N71416Smith Mark E · Mount Morris, NYBuilt 1946 · S/N 2843 N71425Harris Jeremy B · Boring, ORBuilt 1946 · S/N 2852 N71428Walker Ray A · Sanger, TXBuilt 1946 · S/N 2855 N71434Goudeau Todd J · Broussard, LABuilt 1946 · S/N 2861 N71441Oconnell Marcia S Trustee · Coeur D Alene, IDBuilt 1946 · S/N 2868 N71442Grueninger Mark J · Benton, ILBuilt 1946 · S/N 2869 N71448Registered aircraftBuilt 1946 · S/N 2875 N71455Slomer James A · Cheswick, PAS/N 2882 N71461Gumley Jamison J · Wasilla, AKBuilt 1946 · S/N 2888 N71465Baxter Thomas L · Stockbridge, GABuilt 1946 · S/N 2892 N71467Dombrowski Gregory · Mangum, OKBuilt 1946 · S/N 2894 N71470Murphys Flying Service LLC · Thomasville, GAS/N 2897 N71472Bedford Dennis L · Auke Bay, AKBuilt 1946 · S/N 2899 N71476Cruz Jesse · Simi Valley, CABuilt 1946 · S/N 2903 N71479Sale Reported · Elizabeth, COSale reportedBuilt 1946 · S/N 2906 N71480Clark Trevor D · Sheridan, WYS/N 2907 N71486Wasson Tina A · Lakeport, CABuilt 1946 · S/N 2913 N71488Booker Louis E · Pinetop, AZBuilt 1946 · S/N 2915 N71492Adkins Dwain L · Sycamore, ILFirst renewal noticeBuilt 1946 · S/N 2919 N71496Doyle Robin C · Denham Springs, LABuilt 1946 · S/N 2923 N71498Eaton Mark E · Houston, TXBuilt 1946 · S/N 2925 N71499Monahan Robert J · Bulverde, TXBuilt 1946 · S/N 2926 N71500Colomello Charles P · Tillson, NYBuilt 1946 · S/N 2927 N71504Loonam Christopher J · Morgan Hill, CABuilt 1946 · S/N 2931 N71505Argyros William T · Minneapolis, MNBuilt 1946 · S/N 2932 N71507Oreair Richard L · Jacksonville, FLFirst renewal noticeBuilt 1946 · S/N 2934 N71519Lee Joseph B · Oxnard, CABuilt 1946 · S/N 2946 N71523Koch Kirt K · Cleveland, GABuilt 1946 · S/N 2950 N71524Macey Donald L · Fallon, NVBuilt 1946 · S/N 2951 N71529Lindee Daniel J · Star Prairie, WIBuilt 1946 · S/N 2956

Back to Luscombe 8A