Skip to content

Registered aircraft · 843

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

N19405Blenden Stephen R · Orlando, FLBuilt 1977 · S/N 17702569 N19419Dean Aviation LLC · Merritt Island, FLBuilt 1976 · S/N 17702570 N19445Scott Beau · Ashville, OHBuilt 1976 · S/N 17702572 N19501Beardsley Larry N · Leavittsburg, OHBuilt 1976 · S/N 17702574 N19519Gulf Niner LLC · Eagan, MNBuilt 1976 · S/N 17702575 N1954SBarca Sky F · Simi Valley, CABuilt 1974 · S/N 17702197 N19575Galis Iuri · Oklahoma City, OKBuilt 1976 · S/N 17702577 N19665H&L Axelsson Inc · Cape May, NJS/N 17702582 N19700Johnson Dean W · Watertown, SDBuilt 1976 · S/N 17702584 N19712Humble Lewis N · Grand Blanc, MIS/N 17702586 N19748Scaringe William A Jr · Culver City, CABuilt 1976 · S/N 17702588 N19758Walsh Robert F · Tucson, AZBuilt 1976 · S/N 17702589 N19762Boyertown Flying Club Inc · Devon, PABuilt 1976 · S/N 17702590 N19763N19762 LLC · Tigard, ORBuilt 1976 · S/N 17702591 N19782Herber David · Stanwood, WABuilt 1976 · S/N 17702594 N19783Sky Hi Inc · Frederick, MDBuilt 1976 · S/N 17702595 N19787Reinhardt Ryan S · Russell, KSBuilt 1976 · S/N 17702596 N19793Lopez Vicente · San Juan, PRBuilt 1976 · S/N 17702598 N19800Cardinal LLC · South Easton, MABuilt 1976 · S/N 17702599 N19806Overseas Aviation Inc · Wilmington, DEBuilt 1976 · S/N 17702600 N19814Dix Aviation LLC · Indianapolis, INBuilt 1976 · S/N 17702601 N19824Gadola Alan J · Maple Grove, MNBuilt 1976 · S/N 17702605 N19828Walker Clint · Indianapolis, INBuilt 1976 · S/N 17702606 N19847Wheatley William L · Springfield, KYBuilt 1976 · S/N 17702607 N19857Rutledge James M · Cresson, TXBuilt 1976 · S/N 17702608 N19880Mach 1 Pilots Association Inc · Hillsborough, NJBuilt 1977 · S/N 17702610 N19895Fms Aviation LLC · Littlestown, PABuilt 1976 · S/N 17702612 N19976West Mi Shooting Alliance For Excellence In Safety · Marne, MIS/N 17702618 N19977Moody Matthew Joseph · Homewood, ALBuilt 1977 · S/N 17702619 N19JKA P Air LLC · Wilmington, NCBuilt 1973 · S/N 17701867 N19PFTac'S Enterprise LLC · Ballston Lake, NYBuilt 1972 · S/N 17701711 N19TAFun Flyers LLC · Salem, ORBuilt 1973 · S/N 17701912 N1GXOclair Carleton Brent · Saco, MEBuilt 1973 · S/N 17702009 N20008Crabdree Marty D · Conroe, TXBuilt 1977 · S/N 17702621 N20023Usnick Robert W · Mc Donald, PABuilt 1977 · S/N 17702622 N20056Haney Randall M · Boaz, ALBuilt 1977 · S/N 17702624 N20085Fleming Ian · Peoria, AZBuilt 1977 · S/N 17702626 N20094Valiair Lc Trustee · Casper, WYS/N 17702627 N20116Paxton Roger D · Norman, NCFirst renewal noticeS/N 17702630 N20124Cerven Bohuslav Bo · Claremont, CABuilt 1977 · S/N 17702631 N20127Lewallen David H · Alexander, ARBuilt 1977 · S/N 17702633 N20142Johnson Lindley N · Kingstowne, VAS/N 17702635 N20145Avco Patrol LLC · Lyndon, KSS/N 17702636 N20151Binder Andrew S · Santa Barbara, CAS/N 17702637 N20170Cardinal Group · Linden, MIS/N 17702639 N20174Feighny James P · Rockville, MDS/N 17702640 N20192Registered aircraftBuilt 1977 · S/N 17702643 N20204Bellingham James G · Baltimore, MDBuilt 1977 · S/N 17702644 N20214Bingairman LLC · Newville, PABuilt 1977 · S/N 17702645 N20217La Valle Jacque D · Lexington Park, MDBuilt 1977 · S/N 17702646

Back to Cessna 177B