Skip to content

Registered aircraft · 788

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 ('2073709', '2073710')
  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 ('2073709', '2073710')
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.

N177PKTriton 2 LLC · Bowmansville, NYS/N 177RG1196 N177PRGriffin Gregory J · Gobles, MIBuilt 1971 · S/N 177RG0083 N177RGTorske Stephen Nils · Helena, MTS/N 177RG-0048 N177RZCardinal Investigative Alliance Ltd · Chicago, ILBuilt 1976 · S/N 177RG0843 N177SDMillner Paul A · Berkeley, CAS/N 177RG0997 N177SLSimply Living LLC · Fort Myers, FLFirst renewal noticeBuilt 1975 · S/N 177RG0660 N177TGSerenity Aviation LLC · Oxford, NCBuilt 1976 · S/N 177RG0999 N177TKNoblett Ronald D · Bellaire, TXS/N 177RG0781 N177TMWheeler Floyd G · Stanton, TXBuilt 1975 · S/N 177RG0815 N177TXTurbine Aircraft Marketing Inc · Lewisville, TXBuilt 1973 · S/N 177RG0446 N177VBBalthis John A · Pleasant Hill, MOS/N 177RG0113 N177VKKreizinger Natalie · San Diego, CABuilt 1976 · S/N 177RG1066 N177VSBas Part Sales LLC · Greeley, COBuilt 1973 · S/N 177RG0327 N177WBCardinal 3 Flyers LLC · Springfield, OHBuilt 1976 · S/N 177RG0975 N177WFTexoma Redbird LLC · Kingston, OKBuilt 1977 · S/N 177RG1241 N177WPForbes William T · Moorhead, MNBuilt 1974 · S/N 177RG0554 N177WSSchroeder David B · Centennial, WYBuilt 1975 · S/N 177RG0732 N178SKOppenheim Kyle A · Mountain View, CABuilt 1978 · S/N 177RG1320 N17DMLevin Jason Daniel · Aptos, CABuilt 1973 · S/N 177RG0420 N1816QS And E Airplane Company · Puyallup, WABuilt 1971 · S/N 177RG0216 N1817QJohnston Bernard D · Puyallup, WAFirst renewal noticeBuilt 1971 · S/N 177RG0217 N1819QSchmidt Mark · San Jose, CABuilt 1971 · S/N 177RG0219 N1821QPamperien Casey Dean · Manassa, COBuilt 1971 · S/N 177RG0221 N1822QPopiol Victor · Doral, FLBuilt 1971 · S/N 177RG0222 N1826QMiller Brent R · Orefield, PABuilt 1971 · S/N 177RG0226 N1829QMaracle Wayne M Jr · Papillion, NEBuilt 1971 · S/N 177RG0229 N1831QLovejoy Russ · Vian, OKS/N 177RG0231 N1832QSimmons Gordon W · De Leon Springs, FLBuilt 1971 · S/N 177RG0232 N1835QGreen Wendell C · Live Oak, CABuilt 1971 · S/N 177RG0235 N1836QUebersetzig Joshua · Monrovia, CABuilt 1971 · S/N 177RG0236 N1837QHenry Mark S · Endwell, NYBuilt 1971 · S/N 177RG0237 N1840Q6 Cs Air Inc · Tacoma, WABuilt 1971 · S/N 177RG0240 N1841QEvolution Electronics LLC · Superior, WIBuilt 1972 · S/N 177RG0241 N1842QKrause Douglas S · Davis, CABuilt 1971 · S/N 177RG0242 N1843QJohnson Dana J · Winona, MNBuilt 1972 · S/N 177RG0243 N1844QT & E Brothers Inc · Gardena, CABuilt 1972 · S/N 177RG0244 N1846QBucciarelli Tazio E · San Diego, CABuilt 1972 · S/N 177RG0246 N1847QDye Michael M · Bastrop, TXBuilt 1972 · S/N 177RG0247 N1850QVincz Shawn · Williams, INBuilt 1972 · S/N 177RG0250 N1852QTalbot Mitchell R · Queen Creek, AZBuilt 1972 · S/N 177RG0252 N1854QSc Cardinal LLC · Wilmington, DEBuilt 1972 · S/N 177RG0254 N1856QEmpty Hanger LLC · Traverse City, MIBuilt 1972 · S/N 177RG0256 N1858QScott Air LLC · Cave Creek, AZBuilt 1972 · S/N 177RG0258 N1862QB & P Transportation LLC · Mount Blanchard, OHBuilt 1972 · S/N 177RG0262 N1863QCollins David A · Portland, ORBuilt 1972 · S/N 177RG0263 N1866QPez Air LLC · Cleveland Heights, OHBuilt 1972 · S/N 177RG0266 N1870QTrebilco David R · Cedar Park, TXBuilt 1972 · S/N 177RG0270 N1871QHemstad Christopher L · Portland, ORBuilt 1972 · S/N 177RG0271 N1872QQualitair LLC Trustee · MichelstadtBuilt 1972 · S/N 177RG0272 N1876QShuford Lon R · Cumming, GABuilt 1972 · S/N 177RG0276

Back to Cessna 177RG