Skip to content

Registered aircraft · 1,439

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

N8120UTeague Phillip · Lanett, ALBuilt 1976 · S/N 15077891 N8123USterner Thomas M · Wilmington, DEBuilt 1976 · S/N 15077892 N8133UDunaire LLC · Mechanicsburg, PAS/N 15077897 N8138UBurner Dwight L · Mc Gaheysville, VABuilt 1976 · S/N 15077899 N8139USemanskee Grant W · Snohomish, WABuilt 1976 · S/N 15077900 N8144UHansen Kermit E · Ryder, NDBuilt 1976 · S/N 15077901 N8168USale Reported · Three Rivers, MISale reportedBuilt 1976 · S/N 15077905 N8193UClark Jason · West Valley City, UTBuilt 1976 · S/N 15077908 N820MPPrice Michael Wade · Elkton, VABuilt 1975 · S/N 15076861 N820STTwente Ron K · Saint Peters, MOBuilt 1976 · S/N 15078376 N8276UNurge Richard J · Gilroy, CAS/N 15077910 N8298UCollins Roberto · Naples, FLBuilt 1976 · S/N 15077915 N830WHJorgensen Robert M · Tracy, CABuilt 1975 · S/N 15076730 N8313USchmidt Jeffrey L · Granbury, TXS/N 15077918 N8326UHill John R · Seattle, WABuilt 1976 · S/N 15077920 N8355UWilhelm Joshua Robert · Lake Havasu City, AZBuilt 1976 · S/N 15077925 N8360UHead Joseph · Fairbanks, AKS/N 15077927 N8378UMartin Garland L · Zephyrhills, FLBuilt 1976 · S/N 15077929 N8393UMadsen Christian A · Hilton Head Island, SCBuilt 1976 · S/N 15077931 N8440UNicholls Donald B · East Amherst, NYBuilt 1976 · S/N 15077936 N8494URieck Brian M · Junction, TXBuilt 1976 · S/N 15077940 N8503UCropley Alton I · Sitka, AKS/N 15077941 N850DRMooers Michael T · Haggerstown, MDBuilt 1977 · S/N 15079358 N8528UKanning Brandon A · Graham, WABuilt 1976 · S/N 15077943 N8536UIndigo Of South Fl Inc · Sunrise, FLBuilt 1976 · S/N 15077944 N8545UNott Mike · Huntington Beach, CABuilt 1976 · S/N 15077946 N8572USkyline Aviation Solutions LLC · Grosse Ile, MIBuilt 1976 · S/N 15077952 N8590USunrise Legacy Aviation LLC · Corona Del Mar, CABuilt 1976 · S/N 15077955 N8600UCristiano Thomas J · Clifton Park, NYBuilt 1976 · S/N 15077957 N8619USpadaro James · Cross Lanes, WVBuilt 1976 · S/N 15077961 N8621UTomsheck Brothers · Oilmont, MTBuilt 1976 · S/N 15077962 N8634UTango Thirty One Aero Clube Inc · Mckinney, TXBuilt 1975 · S/N 15077246 N8635UTango Thirty One Aero Clube Inc · Mckinney, TXBuilt 1976 · S/N 15077965 N8642UNemerovsky Jason B · Plantation, FLS/N 15077966 N8645URocereta Aaron W · Eagle River, AKBuilt 1976 · S/N 15077967 N8685UBrennan Curtis Callaway · Atlanta, MIS/N 15077970 N8724URonald O Holcomb LLC · Lapeer, MIBuilt 1976 · S/N 15077974 N8730UKachalsky Alan N · Rye, NYBuilt 1976 · S/N 15077975 N8731USemet Marva S · Seattle, WABuilt 1976 · S/N 15077976 N8738URhk Of Kansas · Jefferson City, MOBuilt 1976 · S/N 15077977 N8747URegistration Pending · Indio, CARegistration pendingBuilt 1976 · S/N 15077978 N8755UDouglas-Carter Tammi A · Greenville, KYBuilt 1976 · S/N 15077980 N8760UReid Gary M · Medford, ORS/N 15077982 N8765URebel Metals LLC · Croydon, NHBuilt 1976 · S/N 15077983 N8778UWright Penny L · San Francisco, CAS/N 15077986 N8780UReeves Gary A · Lorimor, IABuilt 1976 · S/N 15077988 N8784UWilson Jacob T · Loma Linda, CABuilt 1976 · S/N 15077991 N8785USchoenling Joseph S · Cincinnati, OHBuilt 1976 · S/N 15077992 N8789ULangley Bryan T · Springfield, OHBuilt 1976 · S/N 15077993 N8790UPonte Ralph M DBA · Grass Valley, CABuilt 1976 · S/N 15077994

Back to Cessna 150M