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.

N3489VMathews Richard III · Cuthbert, GABuilt 1974 · S/N 15076519 N3495VSignal Air Service Inc · Gallatin Gateway, MTBuilt 1974 · S/N 15076523 N3496VRasch James L · Conklin, MIBuilt 1974 · S/N 15076524 N34APPitman Amanda R · Harrah, OKBuilt 1975 · S/N 15076814 N3503VMock Joseph R · Huntsville, TXBuilt 1974 · S/N 15076526 N3507VBrock Aviation Flight School LLC · Douglasville, GABuilt 1974 · S/N 15076528 N3513VHaussler Stephen K · Arlington Heights, ILS/N 15076530 N3519VVanderpool Kenneth J · Portsmouth, NHBuilt 1974 · S/N 15076533 N3534VJervis Joseph · Genoa, WVS/N 15076537 N353JKAirspeed Marketing LLC · Phoenix, AZS/N 15076910 N353WFlight Path Ra LLC · North Miami, FLS/N 15078799 N3540VPearson Victor E · Lake Stevens, WABuilt 1975 · S/N 15076539 N3545VSoaring Pinions LLC · Rittman, OHBuilt 1975 · S/N 15076541 N3554VHayes Kenneth L · Blue Ridge, VABuilt 1975 · S/N 15076545 N3566VMbsp Enterprises Inc · Wilmington, DEBuilt 1975 · S/N 15076548 N3575VSale Reported · Acworth, GASale reportedS/N 15076552 N3584VMurdoch Bryan · Lantana, FLBuilt 1975 · S/N 15076553 N3597VMcleod Patrick J · Overgaard, AZBuilt 1975 · S/N 15076557 N3599VMakee Markus · Painesville, OHBuilt 1975 · S/N 15076558 N3607VDel Vecchio Thomas L · Middlebury, INBuilt 1975 · S/N 15076560 N3622VFox John E · Boonville, CABuilt 1975 · S/N 15076565 N3623VClark Cecil L · Shreveport, LABuilt 1975 · S/N 15076566 N3626VTorres Torres Angel G · Chesapeake, VABuilt 1975 · S/N 15076567 N362LKJackson Brian J · Anchorage, AKS/N 15076026 N3635VTz Airways 1 LLC · Avon Park, FLBuilt 1975 · S/N 15076570 N3638VHope Virginia L · Georgetown, OHS/N 15076571 N3641VWright John C · Windham, MEBuilt 1975 · S/N 15076573 N3663VCordova Jose F · Anaheim, CABuilt 1975 · S/N 15076578 N3664VPerfect Aircraft LLC · Ocala, FLBuilt 1975 · S/N 15076579 N3672VRobinson Franz · Seagrove, NCBuilt 1975 · S/N 15076582 N3673VClinton Flying Service Inc · Clinton, NCBuilt 1975 · S/N 15076583 N3680VAdams James W · Sioux Falls, SDBuilt 1975 · S/N 15076586 N3683VMcflight Aviation LLC · Highland, UTBuilt 1975 · S/N 15076588 N3689VChvatal Daniel A · Jordan, MNBuilt 1975 · S/N 15076592 N3715VAlert Rentals LLC · Pleasant Grove, UTBuilt 1975 · S/N 15076597 N3716VBorton Garrett J · Newcastle, WYBuilt 1975 · S/N 15076598 N3721VMacksamie John M · Rochester, NYBuilt 1975 · S/N 15076600 N3723VPueo Aviation LLC · Honolulu, HIBuilt 1975 · S/N 15076601 N3733VToccoa Aviation · Toccoa, GABuilt 1975 · S/N 15076605 N3734VBurrell Dennis E · Parma, IDS/N 15076606 N3737VClarke Adrian N · Aledo, TXBuilt 1975 · S/N 15076607 N3750VNeal Latimer B IV · Fayetteville, GABuilt 1975 · S/N 15076610 N3766VHaile Kempton Crosby · Warrenton, VABuilt 1975 · S/N 15076612 N3768VHaynes Robert K · Pilot Point, TXBuilt 1975 · S/N 15076614 N3769VSky High Investments LLC · Greenwood, INS/N 15076615 N3776VCoach Masters Inc · Kearney, NES/N 15076619 N3777VOld School Aviation · Ottsville, PABuilt 1975 · S/N 15076620 N3778VSmith Harold J · Poughkeepsie, NYBuilt 1975 · S/N 15076621 N379MBRoeper Gary L · Linden, MIBuilt 1975 · S/N 15077109 N3811VFlying Asian Aviation Inc · Richmond, CANon-citizen corporation, flight hours not reportedBuilt 1975 · S/N 15076630

Back to Cessna 150M