Skip to content

Registered aircraft · 80

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

N110EACenterline Holdings · Camden, DEBuilt 1971 · S/N A1500309 N135AUCoppice Aviation Assets LLC · Lewes, DEBuilt 1971 · S/N A1500297 N1574LNghiem Daniel · Westminster, CABuilt 1973 · S/N A1500460 N1970MAirborne Resources Inc · Midlothian, TXBuilt 1971 · S/N A1500300 N23JRHerrera Pedro · Spring Branch, TXBuilt 1970 · S/N A1500259 N2457FPettyjohn Nancy Paulette Sautebien · Dearborn, MIBuilt 1973 · S/N A1500402 N2458FErickson Timothy M · Mead, NEBuilt 1973 · S/N A1500403 N2572LBuick Robin B · Redding, CABuilt 1973 · S/N A1500485 N3172FKuhn Joseph C · Manhattan Beach, CABuilt 1973 · S/N A1500407 N3517FCebelak William G · Kent City, MIBuilt 1973 · S/N A1500410 N3581FSkyline Aviation Services LLC · Miramar, FLBuilt 1973 · S/N A1500413 N4811FHurlston Glenn D · Leesville, LABuilt 1973 · S/N A1500417 N500SUOhio State University · Columbus, OHBuilt 1974 · S/N A1500486 N53PHHaynes Jason Allen · Justin, TXS/N A1500352 N5928JParsons Royson A · Atascadero, CABuilt 1971 · S/N A1500228 N5942JNovember Sierra Aviation LLC · O Neill, NES/N A1500242 N5949JAnderson Brian E · Castro Valley, CABuilt 1973 · S/N A1500401 N5952JB&R Aircraft LLC · Wadsworth, OHBuilt 1970 · S/N A1500252 N5956JBrogren Nicholas R · Minneapolis, MNS/N A1500256 N5960JWoodward Michael J · Council Bluffs, IABuilt 1971 · S/N A1500260 N5965JI & U Aviation LLC · Lexington, SCS/N A1500265 N5968JAragon Cecilia R · Sequim, WABuilt 1971 · S/N A1500268 N5977JTemplet Eugene P · Pearl River, LABuilt 1971 · S/N A1500277 N5978JVigil Clyde R · Chimayo, NMS/N A1500278 N5987JBoerne Flight Options LLC · Boerne, TXS/N A1500287 N5991JSchutes John T Jr · Port St Joe, FLBuilt 1971 · S/N A1500291 N5992JLinback Ken R · Niles, MIBuilt 1971 · S/N A1500292 N6001JWanda Collins Professional Pilot Services LLC · Madisonville, TXBuilt 1971 · S/N A1500301 N6007JAldrich Richard G · La Habor, CABuilt 1971 · S/N A1500307 N6016JPatterson Roland O · Semmes, ALBuilt 1971 · S/N A1500316 N6018JGagnon Nels D · Globe, AZBuilt 1972 · S/N A1500318 N6023JR&M Steel Co · Caldwell, IDBuilt 1972 · S/N A1500323 N6024JHangar 5 LLC · Wilmington, DEBuilt 1972 · S/N A1500324 N6025JFasking Daniel M · Stanford, ILBuilt 1972 · S/N A1500325 N6027JPark William G · Canby, ORS/N A1500327 N6029JBevc Dimitri · Pleasanton, CABuilt 1972 · S/N A1500329 N6031JThomas C Marcy · Chesterfield, VABuilt 1972 · S/N A1500331 N6041JCandler Field Museum Inc · Griffin, GAS/N A1500341 N6042JGeer Chad C · Murrieta, CABuilt 1972 · S/N A1500342 N6048JAll Elements Aviation LLC · Newnan, GABuilt 1972 · S/N A1500348 N6049JKyne James M Jr · Vacaville, CABuilt 1972 · S/N A1500349 N6051JRobison David · El Dorado, ARBuilt 1972 · S/N A1500351 N6056JAchord James D · Decatur, ALBuilt 1972 · S/N A1500356 N6058JWhitson Freddie B · Llano, TXBuilt 1972 · S/N A1500358 N6065JBrown Charles A · Boise, IDBuilt 1972 · S/N A1500365 N6067JSale Reported · Ephrata, WASale reportedBuilt 1972 · S/N A1500367 N6075JLowrance Kathleen C · Plano, TXBuilt 1972 · S/N A1500375 N6080JRidgewood Corp Inc · Orangeville, PAS/N A1500380 N6084JHatloy Mark · Drayton, NDBuilt 1973 · S/N A1500384 N6087JTexas Youth Flight Experience Foundation · Boerne, TXBuilt 1973 · S/N A1500387

Back to Cessna A150L