Skip to content

Registered aircraft · 1,446

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

N16053Drain Dennis R · Ferndale, WABuilt 1972 · S/N 15073444 N16057Renner Thomas J · Williston, NDS/N 15073447 N16058Northwest Wings LLC · Hillsboro, ORBuilt 1972 · S/N 15073448 N16064Wyatt Scott A · Tehachapi, CABuilt 1972 · S/N 15073451 N1606QChappell Nathan T · Glasgow, MTBuilt 1971 · S/N 15072906 N16073Hobbs Mitchell J · The Villages, FLBuilt 1972 · S/N 15073456 N16074Derstine Ernest B · Pantego, NCS/N 15073457 N16079El Ghawi Andre · Venice, FLBuilt 1972 · S/N 15073461 N16080150 Flyers LLC · Waterford, MIFirst renewal noticeS/N 15073462 N16084Lawson Roger E · Elizabethtown, KYBuilt 1972 · S/N 15073465 N16088Wyrosdick Benjamin S · Hoover, ALBuilt 1972 · S/N 15073467 N16091Timm Mark W · Ithaca, NEBuilt 1972 · S/N 15073469 N16093Hanus Aviation LLC · Kenyon, MNBuilt 1972 · S/N 15073471 N16097Crosswind Capital LLC · Castle Rock, COBuilt 1972 · S/N 15073474 N16101Hatch David G · Clovis, CAS/N 15073477 N16105Stevenson Rodrick Albert · Smyrna, GABuilt 1972 · S/N 15073480 N16107Scheck Robert C · Chicago, ILBuilt 1972 · S/N 15073481 N16108Longsroad LLC · Carefree, AZBuilt 1972 · S/N 15073482 N16109Registration Pending · Mundelein, ILRegistration pendingBuilt 1972 · S/N 15073483 N16114Mcquaid Joseph D · Cosby, TNS/N 15073486 N16120Av8 Flight Assets LLC · Eden Prairie, MNBuilt 1972 · S/N 15073491 N16125Palmer Earl S Jr · Boise, IDBuilt 1972 · S/N 15073494 N16127Skypark Inc · Wadsworth, OHBuilt 1972 · S/N 15073496 N16128Marquette County Flying Club · Marquette, MIBuilt 1972 · S/N 15073497 N16129Rankin Kevin · Maryville, MOBuilt 1972 · S/N 15073498 N16165Registered aircraftBuilt 1972 · S/N 15073514 N16166Hayden Scott M · Walworth, WIBuilt 1972 · S/N 15073515 N16169Trotter Patrick J · North Las Vegas, NVBuilt 1972 · S/N 15073518 N1616QKrehbiel Bradley C · Lake City, MNS/N 15072916 N16174Cirrostrats Inc · Deland, FLBuilt 1972 · S/N 15073523 N16177Norby Aviation LLC · Hopkinton, MABuilt 1972 · S/N 15073525 N16179Farrell Donald A · Owasso, OKBuilt 1972 · S/N 15073527 N1617QAljanabi Mohammed Khalid · Herndon, VAS/N 15072917 N16180Last Mango Air LLC · Fond Du Lac, WIBuilt 1972 · S/N 15073528 N16184Finkel David M · Shelbyville, INS/N 15073530 N16194Booth Jesse R · Alamosa, COBuilt 1972 · S/N 15073537 N16196Macdonald Kaitlyn A · Dillon, MTBuilt 1972 · S/N 15073539 N1619QAmos Carl R · Chandler, INBuilt 1971 · S/N 15072919 N16202Steward Charles M · Tuttle, OKS/N 15073543 N16206Schultz Aviation Services LLC · Crowley, LABuilt 1972 · S/N 15073544 N16207Martinez Jose Antonio · Orlando, FLBuilt 1972 · S/N 15073545 N16210Simpson Dean H · Limon, COBuilt 1972 · S/N 15073546 N16216Scott Jeffrey A · Camden, TNBuilt 1972 · S/N 15073549 N16221Aero Maintenance Inc · Vancouver, WABuilt 1972 · S/N 15073553 N16222Thumser Douglas Francis · Newcastle, CABuilt 1972 · S/N 15073554 N16223Flyhnz LLC · Oxford, NCS/N 15073555 N16225Tumminaro Michael · Neodesha, KSBuilt 1972 · S/N 15073557 N1622QSchweim Robert J · Ocean City, NJBuilt 1971 · S/N 15072922 N16238Hayes Lance Garett · Opelousas, LABuilt 1972 · S/N 15073564 N1623QHigh Exposure Inc · Wilmington, DES/N 15072923

Back to Cessna 150L