Skip to content

Registered aircraft · 303

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

N42EREmbry-Riddle Aeronautical University Inc · Prescott, AZBuilt 1965 · S/N 15061252 N47793Taylor Jimmie D · Hedley, TXBuilt 1965 · S/N 15061406 N5420ECrowder John T · Summerfield, FLBuilt 1963 · S/N 644 N6074TKase Larry E · Sleepy Hollow, ILBuilt 1964 · S/N 15060774 N6079TFookes Raymond R · Lenoir City, TNS/N 15060779 N6084TRipper Ryan · Howell, MIBuilt 1964 · S/N 15060784 N6085TUllmayer Claressa L · Murray, UTBuilt 1964 · S/N 15060785 N6086TCampbell Jack G · Spring Valley, WIBuilt 1964 · S/N 15060786 N6087TGray Bryan D · Colorado City, TXBuilt 1964 · S/N 15060787 N6091TDyck David C · Lake Forest Park, WABuilt 1964 · S/N 15060791 N6092TPurkinje Ltd LLC · Wilmington, DEBuilt 1964 · S/N 15060792 N6108TKidd Matthew D · Huddleston, VAS/N 15060808 N6111TAllen Trevor · Richmond, KYBuilt 1964 · S/N 15060811 N6112TSnell Matthew · Ackerly, TXBuilt 1964 · S/N 15060812 N6115TIngegno Frank N · Carmel, INS/N 15060815 N6120TBaker-Waite Kellie · Pawlet, VTBuilt 1964 · S/N 15060820 N6122TBach James S · Columbus, MTBuilt 1964 · S/N 15060822 N6127TVan Hammers Gary C · Mukwonago, WIS/N 15060827 N6139TGrad Jonathan P · Warroad, MNS/N 15060839 N6142TMiller Timothy A · Opheim, MTBuilt 1964 · S/N 15060842 N6145TJones Blake · Selma, ALBuilt 1964 · S/N 15060845 N6146TDanyal David · Lake Stevens, WABuilt 1964 · S/N 15060846 N6147TBooks Clifton B · Harrah, OKBuilt 1964 · S/N 15060847 N6150THaug Michael A · Spring Lake, MIBuilt 1964 · S/N 15060850 N61561Tangent Aviation LLC · Oro Valley, AZS/N 15060976 N6156TGalster Gabriel M · Royal, ARS/N 15060856 N6157TVlk Mark J · Moses Lake, WABuilt 1964 · S/N 15060857 N6158TWilliams James D · Lyons, COBuilt 1964 · S/N 15060858 N6164TRubin Andrew C · Rochester, NHBuilt 1964 · S/N 15060864 N6167TBurton William F · Shiloh, NJBuilt 1964 · S/N 15060867 N6169TZelner Gregory · Merritt Island, FLBuilt 1964 · S/N 15060869 N6170THerman David B · Seattle, WABuilt 1964 · S/N 15060870 N6172TMckinney Peggy A · Hamersville, OHBuilt 1964 · S/N 15060872 N6173TGreat Pilots LLC · Rocklin, CABuilt 1965 · S/N 15060873 N6176TMatta Figueroa Eduardo · Chapman, KSBuilt 1964 · S/N 15060876 N6178TRobinson Don · Peotone, ILS/N 15060878 N6179TCullipher William L · Texarkana, TXBuilt 1964 · S/N 15060879 N6182TLuxaire Center Inc · Deland, FLS/N 15060882 N6184TBormann Wayne T · Valley Center, KSBuilt 1964 · S/N 15060884 N6185TRobinson David B · Fair Oaks, CABuilt 1964 · S/N 15060885 N6187TGulfstream Design Associates Inc · Delray Beach, FLBuilt 1964 · S/N 15060887 N6189TBlack Archie C · Colton, CABuilt 1964 · S/N 15060889 N6192TAustin James M · Fort Worth, TXS/N 15060892 N6193TAl Banna Emad R · Huntingtown, MDBuilt 1964 · S/N 15060893 N6194TFielden Larry · Sanger, CABuilt 1964 · S/N 15060894 N6198TLim Ronald · Redding, CABuilt 1964 · S/N 15060898 N6201THowett Robert L · Pikeville, NCS/N 15060901 N6203RCannon Elliot M · Paso Robles, CABuilt 1965 · S/N 15061503 N6204TFlory Michael S · Baxley, GABuilt 1964 · S/N 15060904 N6206RHagan Steve P · Mexico, MOBuilt 1965 · S/N 15061506

Back to Cessna 150E