Skip to content

Registered aircraft · 1,636

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

N757HHA&R Aero LLC · Sacramento, CAS/N 15279749 N757HMSchmitt Rudy · Brookshire, TXS/N 15279753 N757HTParrish Aviation Flight Academy LLC · Southlake, TXS/N 15279759 N757HVPropel Air LLC · Pottstown, PABuilt 1977 · S/N 15279761 N757HXAppalachian Aviation LLC · Harrisonburg, VABuilt 1977 · S/N 15279763 N757HYWings Over Texas Holdings LLC · Denton, TXBuilt 1977 · S/N 15279764 N757JDSuburban Air Corp · Castro Valley, CABuilt 1977 · S/N 15279769 N757JGJet & Rotor Aviation LLC · Sacramento, CABuilt 1977 · S/N 15279772 N757JJJetstream Aeronautics LLC · San Antonio, TXBuilt 1977 · S/N 15279774 N757JKMcdermotts Letsfly LLC · Somerton, AZBuilt 1977 · S/N 15279775 N757JXHillsboro Aero Academy LLC · Hillsboro, ORBuilt 1977 · S/N 15279787 N757JYBreuer Lisa M · Horseshoe Bend, IDBuilt 1977 · S/N 15279788 N757KFBob Hoover Academy · Salinas, CABuilt 1977 · S/N 15279795 N757KMClover Park Technical College · Tacoma, WABuilt 1977 · S/N 15279801 N757KXDamian Davis Construction Co · Candler, NCBuilt 1977 · S/N 15279811 N757LBSwaney Brian W · Pendleton, SCBuilt 1977 · S/N 15279815 N757LGMamet Oren · Andover, MABuilt 1977 · S/N 15279820 N757LMYeary Clifton K · Quitaque, TXBuilt 1977 · S/N 15279825 N757LNWings Over Texas Holdings LLC · Denton, TXBuilt 1977 · S/N 15279826 N757LPPrice Thomas E · Ogden, UTFirst renewal noticeBuilt 1977 · S/N 15279827 N757LXSt Louis Flight Training LLC · Cahokia, ILBuilt 1977 · S/N 15279835 N757LYHillsboro Aero Academy LLC · Hillsboro, ORBuilt 1977 · S/N 15279836 N757MGOhio Gypsum Floors LLC · Westerville, OHBuilt 1977 · S/N 15279844 N757MMDsr-Cherokee 180 LLC · Dallas, TXBuilt 1977 · S/N 15279849 N757MPAvcorp Holdings Inc · Jackson, MIBuilt 1977 · S/N 15279851 N757MSAngel Aviation Inc · Peoria, AZS/N 15279854 N757MYStaley Grady R · Liberty, NCBuilt 1977 · S/N 15279860 N757NGWeisman Craig A · Falls Of Rough, KYBuilt 1977 · S/N 15279868 N757NJSpace Coast Aircraft Co · Merritt Island, FLBuilt 1977 · S/N 15279870 N757NNCarton David M · Claremont, NHBuilt 1977 · S/N 15279874 N757NQA&R Aero LLC · Sacramento, CABuilt 1977 · S/N 15279876 N757PMKaiser Gavin · Peachtree City, GAS/N 15279896 N757PPFields Joseph H · Placerville, CABuilt 1977 · S/N 15279898 N757PTPavlock Russell H · Tinley Park, ILBuilt 1977 · S/N 15279902 N757QBHutchison William B · Canton, OKBuilt 1977 · S/N 15279910 N757QHWings Over Texas Holdings LLC · Denton, TXBuilt 1977 · S/N 15279916 N757QJWaters Thomas J · Hampton, GABuilt 1977 · S/N 15279917 N757QQKostelecky Scott J · Decatur, TXBuilt 1977 · S/N 15279923 N757RATorello Marty A · Port Huron, MIBuilt 1978 · S/N 15279933 N757RLRudak Phillip Richard · Wethersfield, CTBuilt 1977 · S/N 15279943 N757RNSky Aviation & Maintenance Inc · Wildomar, CAS/N 15279945 N757RPBoyne Valley Flyers Club Inc · Boyne Falls, MIBuilt 1977 · S/N 15279946 N757RTEnright Darren R · Lakeville, MNBuilt 1977 · S/N 15279950 N757RZCox Derrell L · Pamplico, SCS/N 15279956 N757SCHicks Byron · Manchaca, TXBuilt 1977 · S/N 15279959 N757SDYu Hermon Lemuel C · Mays Landing, NJBuilt 1977 · S/N 15279960 N757STChester Charter Inc · Chester, CTBuilt 1977 · S/N 15279974 N757SWSt Charles Flying Service Inc · Portage Des Sioux, MOBuilt 1977 · S/N 15279977 N757TAHofmeister Laurence C · Punta Gorda, FLBuilt 1977 · S/N 15279981 N757TDNew Horizon Aviation Inc · Warwick, RIBuilt 1977 · S/N 15279984

Back to Cessna 152