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

N9804JOrmond Aircraft Leasing & Management Inc · Ormond Beach, FLBuilt 1975 · S/N A1500613 N9809JRies Roger W · Franklin, INS/N A1500618 N9810JBradley Eric Leon · Anthony, NMBuilt 1976 · S/N A1500619 N9811JJones Mark D · Corsicana, TXBuilt 1975 · S/N A1500620 N9817JDonahue Patrick J · Carriere, MSBuilt 1975 · S/N A1500626 N9819JFranco Louise A · El Cerrito, CABuilt 1975 · S/N A1500628 N9820JBenair LLC · Bonita Springs, FLBuilt 1975 · S/N A1500629 N9822JSiskiyou Pacific Inc · Central Point, ORBuilt 1975 · S/N A1500631 N9828JIcarus Copters LLC · Lancaster, CABuilt 1975 · S/N A1500637 N9830JJohnsen Christian · Big Bear Lake, CAS/N A1500639 N9831JHaddix Stanley D · Hagerhill, KYBuilt 1975 · S/N A1500640 N9832JWolfe William Keith · Greenbrier, ARBuilt 1975 · S/N A1500641 N9835JCrooks Curtis L · Truckee, CABuilt 1975 · S/N A1500644 N9839JDarling Dudley W · Northborough, MABuilt 1975 · S/N A1500648 N9840JBean James P · Tulsa, OKBuilt 1975 · S/N A1500649 N9851JPlanepower LLC · Meridian, MSBuilt 1976 · S/N A1500660 N9852JG & M Associates LLC · Quitman, GABuilt 1976 · S/N A1500661 N9854JAdams James P · Wilbraham, MAS/N A1500663 N9857JReiss Alan T · Puyallup, WABuilt 1976 · S/N A1500666 N9859JNghiem Daniel · Westminster, CAS/N A1500668 N9864JCottrell James · Mililani, HIBuilt 1976 · S/N A1500673 N9865JNine Winds Inc · Wilmington, DEBuilt 1976 · S/N A1500674 N9873JRichards Bradley R · Lake Oswego, ORBuilt 1976 · S/N A1500682 N9875JShaw Aviation LLC · Solomon, KSBuilt 1976 · S/N A1500684 N9879JMccormack Robert · Sacramento, CAS/N A1500688 N9882JS&L Aviation LLC · Ashland, OHBuilt 1976 · S/N A1500691 N9884JDubberly David E · St Simons Island, GABuilt 1976 · S/N A1500693 N9890JOrmond Aircraft Leasing & Management Inc · Ormond Beach, FLBuilt 1976 · S/N A1500699 N9894JKosko Stanley G · Seattle, WABuilt 1976 · S/N A1500703 N9896JVande Berg David M · Sioux Center, IABuilt 1976 · S/N A1500705

Back to Cessna A150M