Skip to content

Registered aircraft · 3,572

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

N31LDGustte Phil · North Fort Myers, FLBuilt 1973 · S/N 17262736 N320DDBronson Robert D Trustee · Prineville, ORBuilt 1972 · S/N 17261193 N321TJCole Warren G · Watkinsville, GABuilt 1976 · S/N 17266807 N328DDLandsburg Custom Services LLC · Sandusky, MIBuilt 1973 · S/N 17262401 N329JFJ F Aviation Inc · Joliet, ILBuilt 1975 · S/N 17265835 N32BEWisecup Wilbur V Jr · Germantown, OHBuilt 1974 · S/N 17263249 N32GVEastern Cincinnati Aviation Inc · Batavia, OHS/N 17267026 N3327GWhitewater Aviation Inc · Harrison, OHBuilt 1972 · S/N 17261224 N333BTVaughan Garland Lynn · Canyon, TXBuilt 1975 · S/N 17265369 N333CEFera Margaret L · Allentown, PABuilt 1975 · S/N 17265260 N333KNKris Noone Air LLC · Wilmington, DEBuilt 1973 · S/N 17261426 N339JCNorman Robert Alan · Zanesville, OHBuilt 1973 · S/N 17262119 N33CDElliott Kathy · South Thomaston, MEBuilt 1973 · S/N 17260989 N3426DGaither Timothy · Inman, KSBuilt 1974 · S/N 17264275 N345DESale Reported · Dover, DESale reportedBuilt 1972 · S/N 17260806 N345KRBlue Sky Aviation Cayman Inc · Wilmington, DEBuilt 1974 · S/N 17264632 N345WAWiseman Aviation Inc · Flagstaff, AZBuilt 1976 · S/N 17267522 N3461WBplj LLC · Old Monroe, MOBuilt 1972 · S/N 17261257 N347CHAce Flight Center · St Thomas, VIBuilt 1974 · S/N 17263661 N348CHAce Flight Center Inc · St Thomas, VIS/N 17266564 N349JMMortland Joseph A · Weymouth, MABuilt 1973 · S/N 17262619 N3514QReed Daniel E · Wentzville, MOBuilt 1973 · S/N 17261659 N3522QRamirez Jose Marcos · Casa Grande, AZBuilt 1973 · S/N 17261661 N3535QBoulton Stephen A · Eugene, ORBuilt 1973 · S/N 17261666 N3551QHeatley Thomas L Jr · Gleason, TNBuilt 1973 · S/N 17261670 N355VAVictory Aviation Club Inc · Hamilton, OHBuilt 1976 · S/N 17267135 N3563QKd3262 LLC · Downers Grove, ILBuilt 1973 · S/N 17261673 N3567QIosco Flying Club · East Tawas, MIBuilt 1973 · S/N 17261674 N356TAFlyktoc LLC · Lavonia, GABuilt 1976 · S/N 172-67123 N3572QFloyd Richard C · Sutter Creek, CABuilt 1973 · S/N 17261676 N3573QFly Lugu LLC · Westfield, MABuilt 1973 · S/N 17261677 N3577QSousa Joao P · Prince Frederick, MDBuilt 1973 · S/N 17261678 N3580QSale Reported · Boise, IDSale reportedBuilt 1973 · S/N 17261680 N3581QQuantie Harold G · Locust Grove, OKBuilt 1973 · S/N 17261681 N3585QLerner Daniel A · East Durham, NYBuilt 1973 · S/N 17261685 N3587QBerger Donald D · Ilwaco, WABuilt 1973 · S/N 17261687 N3589QHalfpap Rodney J · Quincy, ILBuilt 1973 · S/N 17261689 N3592QCentral Arkansas Flying Club Inc · Bryant, ARBuilt 1973 · S/N 17261692 N3593QKettunen Alan C · Ashtabula, OHBuilt 1973 · S/N 17261693 N3594QGribble Ted A · Paris, TXBuilt 1973 · S/N 17261694 N359ALTyson Aviation LLC · Sherrills Ford, NCBuilt 1973 · S/N 17262020 N3644TArizona Air Salvage · Phoenix, AZS/N 17260849 N369PPPositive Attitude Ia LLC · Gaithersburg, MDBuilt 1974 · S/N 17263099 N369SPXin Han Aviation LLC · Helena, MTS/N 17262809 N36JCSafety In Motion Flight Center Inc · Puyallup, WABuilt 1973 · S/N 17261759 N36JWBarr Air Patrol LLC · Mesquite, TXBuilt 1975 · S/N 17265589 N36ZQNorthern Flights LLC · Calumet, MIBuilt 1975 · S/N 17265019 N375YVBisono Pablo R · San Juan, PRBuilt 1974 · S/N 17262930 N381MGMissionary Air Group Inc · Burlington, NCBuilt 1975 · S/N 17265873 N382JNSilver Sky Air LLC · Fresno, CABuilt 1973 · S/N 17262794

Back to Cessna 172M