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.

N5715EStephany Peter · Umatilla, FLS/N 17215 N5716EMoore Aviation LLC · Cedar Springs, MIS/N 17216 N5717ELee Terry R · Little Canada, MNS/N 17217 N5722EWinfrey Walter A Trustee · Auburn, CABuilt 1959 · S/N 17222 N5724EGroup 59 LLC · Oro Valley, AZBuilt 1959 · S/N 17224 N5728EThibodeau Thomas J · Honea Path, SCBuilt 1959 · S/N 17228 N5729ERhoades James W · Little Falls, MNBuilt 1959 · S/N 17229 N5734ENewton Victor L · Ozona, TXBuilt 1959 · S/N 17234 N5737EMcdonald Jake V · Bowling Green, MOBuilt 1959 · S/N 17237 N5739EDuggins Terry W · Bremerton, WAS/N 17239 N5741EHatley Ralph A · Eagle Creek, ORBuilt 1959 · S/N 17241 N5742EMarcum Vernon · Huntington, WVBuilt 1959 · S/N 17242 N5743EHock Aviation LLC · Culbertson, NEBuilt 1959 · S/N 17243 N5744EThwing Randy L · Las Vegas, NVBuilt 1959 · S/N 17244 N5745EDicey Charles E · Dothan, ALBuilt 1959 · S/N 17245 N5750EMellen Roger B · Winston, ORBuilt 1959 · S/N 17250 N5755EWilken Christopher W · Milford, IABuilt 1959 · S/N 17255 N5758EStrenger Thorsten · Orlando, FLS/N 17258 N5759EHarrison Gary L · New London, WIBuilt 1959 · S/N 17259 N5770EEagle Aviation LLC · Spearfish, SDBuilt 1959 · S/N 17270 N5773EOppegard Nicholas · Eagle River, AKS/N 17273 N5775EGates Rebecca S · GeorgetownNon-citizen corporation, flight hours not reportedS/N 17275 N5776EHayden Dale G · Salome, AZBuilt 1959 · S/N 17276 N5781ECopithorne Richard J · West Paris, MES/N 17281 N5785ELuxaire Center Inc · Deland, FLBuilt 1959 · S/N 17285 N5789ECoston Kenley R · Powderly, TXBuilt 1959 · S/N 17289 N5790ESale Reported · Pahrump, NVSale reported, canceledS/N 17290 N5792EConrad Edgar H · Mc Alpin, FLS/N 17292 N5793ELowe David M · Sacramento, KYBuilt 1959 · S/N 17293 N5795ERose Walter W · Arena, WIBuilt 1959 · S/N 17295 N5798EPineapple Flyers Inc · Rockville, MDBuilt 1959 · S/N 17298 N5802EMcdougall James R · Las Vegas, NVBuilt 1959 · S/N 17302 N5804EAncona Edward T · Altadena, CABuilt 1959 · S/N 17304 N5810EAsencio Garcia Enrique R · Fort Worth, TXBuilt 1959 · S/N 17310 N5812EKnutson Wayne R · Thompson, NDBuilt 1959 · S/N 17312 N5813EAldrich Curtiss R · Big Oak Flat, CABuilt 1959 · S/N 17313 N5814EShiles Charles E · Payson, AZBuilt 1959 · S/N 17314 N5821ESutherland Gary M · Tucson, AZBuilt 1959 · S/N 17321 N5825EN5825e LLC · Hurricane, WVBuilt 1959 · S/N 17325 N5827EKlassen Joshua L · Cisco, TXBuilt 1959 · S/N 17327 N5831ECampbell Jennings R · Bell, FLBuilt 1959 · S/N 17331 N5834EKendall Samuel · Fairbanks, AKBuilt 1959 · S/N 17334 N5835ELaw Brian W · Brodhead, WIBuilt 1959 · S/N 17335 N5836ESchulz Michael A · Upland, CABuilt 1959 · S/N 17336 N5840ETnw Aviation LLC · Clinton, ARS/N 17340 N5843EMedlin Wayne D · Marshville, NCFirst renewal noticeBuilt 1959 · S/N 17343 N5846ESale Reported · Ohatchee, ALSale reported, pending cancellationBuilt 1959 · S/N 17346 N5856EBudde Bobby Jr · San Jose, CAS/N 17356 N5859EFee Eamon · Winchester, MABuilt 1959 · S/N 17359 N5860ENeary John R · Ridgefield, NJBuilt 1959 · S/N 17360

Back to Cessna 150