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.

N66753Andreasen Trevor C · Springville, UTBuilt 1974 · S/N 15076252 N66755Fischer A Edward Jr · Hampstead, NHBuilt 1974 · S/N 15076253 N66756Listzwan James · High Springs, FLBuilt 1974 · S/N 15076254 N66758Dahlberg James C · Ogilvie, MNBuilt 1974 · S/N 15076255 N66768Ludemann John K · Enfield, CTBuilt 1974 · S/N 15076262 N66774Kilo Lima LLC · Hicksville, NYBuilt 1974 · S/N 15076268 N66776Broherd James · Natalia, TXBuilt 1974 · S/N 15076269 N66777Lennon Bobby M · Whiteville, NCS/N 15076270 N66779Blinn Philipp Randy · Priest River, IDS/N 15076272 N66780Keenan Jim F · Neenah, WIBuilt 1974 · S/N 15076273 N66781Strong Mack A · Coral Springs, FLS/N 15076274 N66785Destefano Patrick S · Bryan, TXBuilt 1974 · S/N 15076278 N66786Gibb Bryce M · Portland, TXBuilt 1974 · S/N 15076279 N66790Logan Dan P · Gilliam, LABuilt 1974 · S/N 15076283 N66LLLetourneau Duane R · Oconto, WIBuilt 1974 · S/N 15076289 N671HABartek Ronald · Lake Charles, LAS/N 15076505 N6993VRegistration Pending · Harvey, NDRegistration pendingS/N 15077956 N6ZBAsh Reed · Atlanta, GABuilt 1974 · S/N 15075784 N704AAWasatch Industries LLC · Ogden, UTBuilt 1976 · S/N 15078448 N704ACRegistered aircraftBuilt 1976 · S/N 15078450 N704AEYocom Jason D · Cocoa, FLBuilt 1976 · S/N 15078452 N704AHN704ah LLC · Darien, WIBuilt 1976 · S/N 15078455 N704ASAuger Allan D · Conifer, COS/N 15078464 N704ATLongnecker Michael · Stuttgart, ARFirst renewal noticeBuilt 1976 · S/N 15078465 N704AULosey Rodric O · Nipomo, CABuilt 1976 · S/N 15078466 N704AWKroeger Dean · Two Rivers, WIBuilt 1976 · S/N 15078468 N704AYAndreasen Mark D · Ridgefield, WABuilt 1976 · S/N 15078470 N704AZFrantz Dean A · Adrian, MIBuilt 1976 · S/N 15078471 N704BEGore Cleveland · Manning, SCS/N 15078475 N704BGJones Kermit L III · Jasper, ALBuilt 1976 · S/N 15078477 N704BHCloud Buddies LLC · Charlotte, NCBuilt 1976 · S/N 15078478 N704BMEdwards Richard V · Acampo, CABuilt 1976 · S/N 15078482 N704BRRourke William P · Lavonia, GAS/N 15078486 N704BZFranks John W · Barberton, OHBuilt 1976 · S/N 15078494 N704CACircle S Aviation LLC · Starkville, MSBuilt 1976 · S/N 15078495 N704CBLewis Stephen · Hayden, IDBuilt 1976 · S/N 15078496 N704CEB2w Corporation · Winona, MNBuilt 1976 · S/N 15078498 N704CFWilbur Blake G · Kent, WABuilt 1976 · S/N 15078499 N704CMCarpenter Devon W · Mountain Top, PABuilt 1976 · S/N 15078505 N704CNTm Aero Marine Inc · North Miami, FLBuilt 1976 · S/N 15078507 N704CSHolloway James H · Merritt Island, FLBuilt 1976 · S/N 15078511 N704CURogers Gale Allen · Jonesborough, TNBuilt 1976 · S/N 15078513 N704CXAlbatross Air Inc · Beaver, WVBuilt 1976 · S/N 15078516 N704CYKimbrel Michael R · Shreveport, LABuilt 1976 · S/N 15078517 N704CZCook David · Tucson, AZBuilt 1977 · S/N 15078518 N704DBAndrews University · Berrien Springs, MIBuilt 1976 · S/N 15078519 N704DFMaples Andrew L · Wilmington, DES/N 15078523 N704DGEastern Florida State College · Cocoa, FLBuilt 1976 · S/N 15078524 N704DHDelaware River Flyers LLC · Dover, DEBuilt 1976 · S/N 15078525 N704DJStevens Robert L · Wauseon, OHBuilt 1976 · S/N 15078526

Back to Cessna 150M