Skip to content

Registered aircraft · 387

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

N5998EAir Heritage Inc · Beaver Falls, PABuilt 1959 · S/N 17498 N5999EBender Evan Dh · Linville, VABuilt 1959 · S/N 17499 N6114TThompson Matthew K · Tuscaloosa, ALBuilt 1964 · S/N 15060814 N6219TCode4 Ventures Inc DBA · Waynesboro, VABuilt 1964 · S/N 15060919 N6237TReinhardt Larry L · Clackamas, ORBuilt 1964 · S/N 15060937 N6400TCampbell Larry L · Fort Mill, SCBuilt 1959 · S/N 17800 N6403TSawicki Michael T · Midland, MIS/N 17803 N6404TWestrum Enterprises LLC · Norwalk, IABuilt 1959 · S/N 17804 N6405TBrunks Paul D · Peachtree City, GAS/N 17805 N6407TKane Erik W · Mojave, CABuilt 1959 · S/N 17807 N6408THowland Timothy A · Mankato, MNBuilt 1960 · S/N 17808 N6409TAubert Thomas R · Redwood City, CAS/N 17809 N6415TEnglish Gary M · Clermont, FLBuilt 1959 · S/N 17815 N6416TMitchell Paula E · Norman, OKBuilt 1959 · S/N 17816 N6417TBazeley Paul J · Aurora, ORS/N 17817 N6419TBaich Michael V · Coleraine, MNBuilt 1959 · S/N 17819 N6421TOlmstead Richard M · Grand Rapids, MIS/N 17821 N6422TRegistration Pending · Vidalia, LARegistration pending, pending cancellationBuilt 1959 · S/N 17822 N6424TOlson James D · New Prague, MNS/N 17824 N6427TBurns Michael P · Lawrenceville, GABuilt 1960 · S/N 17827 N6431THarrigan Bernard J · Fontana, WIBuilt 1960 · S/N 17831 N6434THoran Jack F · De Berry, TXBuilt 1960 · S/N 17834 N6436TWalker Billy W · Dallas, GABuilt 1960 · S/N 17836 N6437TOcotillo Wells Mobile Off Road Rentals Inc · Cardiff By The Sea, CABuilt 1960 · S/N 17837 N6438TCactus Clover Inc · El Paso, TXBuilt 1960 · S/N 17838 N6442TKasparian David W · Deming, NMBuilt 1960 · S/N 17842 N6446TRegistered aircraftBuilt 1960 · S/N 17846 N6450TEllis Samuel F Jr · Copperas Cove, TXBuilt 1960 · S/N 17850 N6451THall Martha A · Borrego Springs, CABuilt 1960 · S/N 17851 N6452TLeopardi Holly F · Albuquerque, NMS/N 17852 N6458TContinental Title Trust LLC · Wichita, KSS/N 17858 N6459TRohlman Aaron · Republic, MOBuilt 1960 · S/N 17859 N6462TAdkins George E · Brooklyn, IABuilt 1960 · S/N 17862 N6463TKemmerling Lawrence W · Mazama, WAS/N 17863 N6466TFirefly Aviation LLC · Apison, TNBuilt 1960 · S/N 17866 N6468TFlying Squirrels LLC · Marietta, GABuilt 1960 · S/N 17868 N6470TWallace Nicholas R · Lynnwood, WABuilt 1960 · S/N 17870 N6472TCamp Harper LLC · Houston, TXBuilt 1960 · S/N 17872 N6478TBasic Daniel J · Mulberry, FLBuilt 1960 · S/N 17878 N6479TDrury Isaac W · Milton, FLBuilt 1960 · S/N 17879 N6483TFoothill Aviation LLC · Iliamna, AKS/N 17883 N6492TSkyway Aviation LLC · Port Jeff Sta, NYBuilt 1960 · S/N 17892 N6495TSale Reported · Tucson, AZSale reportedBuilt 1960 · S/N 17895 N6497TLane Leota P · Alexandria, OHS/N 17897 N6501TPuls Eric S · Ft Rucker, ALBuilt 1960 · S/N 17901 N6508TManchester Eric S · Milton, VTBuilt 1960 · S/N 17908 N6512TJestes Monte G · Stillwater, OKS/N 17912 N6516TMiller Shawn C · Milaca, MNBuilt 1960 · S/N 17916 N6518TMcclintock Matthew · Oscoda, MIS/N 17918 N6524TParks Sam E Jr · Lytle, TXBuilt 1960 · S/N 17924

Back to Cessna 150