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.

N101CWAtlanta Technical College · Atlanta, GABuilt 1972 · S/N 177RG0290 N1075MDewitt Scott C · Corpus Christi, TXBuilt 1973 · S/N 177RG0295 N108ATKirschner John R · Crystal Lake, ILBuilt 1971 · S/N 177RG0046 N110DWSlater Spray Service Inc · Maddock, NDBuilt 1974 · S/N 177RG0495 N1217MFlanders John D · Saunderstown, RIBuilt 1973 · S/N 177RG0400 N1223MRussell Brian K · Phoenix, AZBuilt 1974 · S/N 177RG0504 N122WRRangers Flying Club Inc · Eden Prairie, MNBuilt 1975 · S/N 177RG0744 N123LSBlackford Robert G · Summit Point, WVBuilt 1973 · S/N 177RG0334 N123WEFogg Britt · Springdale, ARBuilt 1974 · S/N 177RG0628 N12HBAerotechniques LLC · South Kent, CTBuilt 1977 · S/N 177RG1124 N1371MPlamondon Jon Trustee · Reno, NVBuilt 1971 · S/N 177RG0081 N138RCBardin G W · Granville, NYBuilt 1976 · S/N 177RG0994 N1432KCovenant Physician Services Ltd · London, OHBuilt 1975 · S/N 177RG0665 N1521HHopkins John C Jr · Tallulah, LABuilt 1975 · S/N 177RG0698 N1525HKubasch Kevin M · Longville, MNBuilt 1975 · S/N 177RG0701 N1526HThompson Roy Dayton · Bulverde, TXBuilt 1975 · S/N 177RG0702 N1534HCooley Norbert · Elkton, MDBuilt 1975 · S/N 177RG0709 N1535HStramer Todd Personal Representative · Hazelton, NDBuilt 1975 · S/N 177RG0710 N1539HAve Maria LLC · Batesville, INBuilt 1975 · S/N 177RG0713 N1540HFurtick Reginald D · Iuka, MSBuilt 1975 · S/N 177RG0714 N1541HAtkin Cris R · St George, UTBuilt 1975 · S/N 177RG0715 N1542HCessna N1542h LLC · Fond Du Lac, WIBuilt 1975 · S/N 177RG0716 N1544HBaugh Ashton C · Petal, MSBuilt 1975 · S/N 177RG0718 N1548HShrader Brian K · Marion, INBuilt 1975 · S/N 177RG0722 N1552HLewis Daniel Bryce · Waller, TXBuilt 1975 · S/N 177RG0726 N1553HBuckner Robert M · Eufaula, OKBuilt 1975 · S/N 177RG0727 N1557HOpequon LLC · Vanderbilt, PABuilt 1975 · S/N 177RG0731 N1559HCardair Inc · Allentown, PABuilt 1975 · S/N 177RG0733 N1560HFly North Of Known LLC · Aurora, ORBuilt 1975 · S/N 177RG0734 N1561HTorpey Richard T · Bay Shore, NYBuilt 1975 · S/N 177RG0735 N1563HSpokane Cardinal · Spokane Valley, WABuilt 1975 · S/N 177RG0737 N1565HSchornick Brad W · Oklahoma City, OKBuilt 1975 · S/N 177RG0739 N1566HRohlfing Gregory C · Elmwood Park, ILBuilt 1975 · S/N 177RG0740 N1567HKrimminger Michiel · Lancaster, SCBuilt 1975 · S/N 177RG0741 N1568HCorner Jeremy M · Peachtree City, GABuilt 1975 · S/N 177RG0742 N1569HDekalb Cardinal LLC · Evanston, ILBuilt 1975 · S/N 177RG0743 N1571HYork Ronald A · West Lafayette, INBuilt 1975 · S/N 177RG0745 N1575HCardinal Shares Inc · Rochester, MNS/N 177RG0749 N1578HKramer Jason K · Longview, TXBuilt 1975 · S/N 177RG0752 N1580HBrock Bobby Charles · New Braunfels, TXBuilt 1975 · S/N 177RG0754 N1581HNevarrow Leon · Spring Valley, CAS/N 177RG0755 N1582HT G & P Enterprises LLC · Glendale, AZBuilt 1978 · S/N 177RG1364 N1587HFowler James C · San Angelo, TXBuilt 1975 · S/N 177RG0761 N1589HAg Scouting Solutions LLC · Huntingdon, TNBuilt 1975 · S/N 177RG0763 N1590HWieting Roger L · Longview, TXBuilt 1975 · S/N 177RG0764 N1593HKleinert John K · Baldwin, GABuilt 1975 · S/N 177RG0767 N1595HSholy Fred · Granada Hills, CAS/N 177RG0769 N1597HAerobox LLC · Seattle, WABuilt 1975 · S/N 177RG0771 N1607HHanson Jeffrey L · Fuquay Varina, NCBuilt 1975 · S/N 177RG0780 N1611HPlane Fun Inc Tr Trustee · Snellville, GABuilt 1975 · S/N 177RG0784

Back to Cessna 177RG