Skip to content

Registered aircraft · 617

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

N5721TSeattle Seaplanes LLC · Seattle, WABuilt 1964 · S/N 17251621 N5723TColeman David R · Limerick, MEBuilt 1964 · S/N 17251623 N5726THall Edward M · Brainerd, MNBuilt 1964 · S/N 17251626 N5729TConservair Inc · Montgomery, TXBuilt 1964 · S/N 17251629 N5731TUhen Instruments Inc · Burlington, WIS/N 17251631 N5733TCountry Flyin Inc · Homestead, FLBuilt 1964 · S/N 17251633 N5736TSparks Fly LLC · Mount Gilead, OHS/N 17251636 N5742TSkyhawkfive LLC · Claremont, NHS/N 17251642 N5743TRay Aviation LLC · Burkett, TXBuilt 1964 · S/N 17251643 N5744TMorris Charles E · Ft Worth, TXBuilt 1964 · S/N 17251644 N5746TWolfe John E · Bay Point, CABuilt 1964 · S/N 17251646 N5747TMontgomery Robert L · Kingman, AZBuilt 1964 · S/N 17251647 N5748TKelly Walter T · Winona, MNBuilt 1964 · S/N 17251648 N5749TEast Fork Aviation LLC · Brandon, MSBuilt 1964 · S/N 17251649 N5751TGordon Robert A · North Pole, AKS/N 17251651 N5752TStrahan Gary · Beaumont, TXBuilt 1964 · S/N 17251652 N5755TD2 Government Solutions LLC · New Bern, NCBuilt 1964 · S/N 17251655 N5757TFive Seven Tango Inc · Fitchburg, WIBuilt 1964 · S/N 17251657 N5763TLumgair David R · Painter, VABuilt 1964 · S/N 17251663 N5765TRawareo LLC · Warsaw, MOBuilt 1964 · S/N 17251665 N5766TJanson Flying Service Inc · Wadena, MNBuilt 1964 · S/N 17251666 N5768TCrouse Sheldon · Mount Pleasant, NCBuilt 1964 · S/N 17251668 N5776TClark Jeffrey Wayne · Piedmont, MOBuilt 1964 · S/N 17251676 N5778TGreen Hornet Aviation LLC · Bloomsburg, PABuilt 1964 · S/N 17251678 N5779TArdmore Aviation LLC9667 · Novelty, OHBuilt 1964 · S/N 17251679 N5781TCortis Samuel L · Uniontown, PABuilt 1964 · S/N 17251681 N5782TLas Capital Corp · St Johns, FLBuilt 1964 · S/N 17251682 N5786TBam Aviation LLC · Santa Ana, CABuilt 1964 · S/N 17251686 N5788THart Justin Owen · Olalla, WAS/N 17251688 N5790TViramontez Walter P · Santee, CABuilt 1964 · S/N 17251690 N5791TShinn Jeffrey D · Weatherford, TXBuilt 1964 · S/N 17251691 N5792TMorgan Dennis A · Middle River, MDBuilt 1964 · S/N 17251692 N5793TJefferson County Public Schools · Louisville, KYBuilt 1964 · S/N 17251693 N5794TGodfrey Kenneth E · Oroville, CABuilt 1964 · S/N 17251694 N5799TGs Air LLC · Sioux Falls, SDS/N 17251699 N6549KBurchinal Sam · Brookston, TXS/N 17251306 N688DDPropit Inc · Wilmington, DES/N 17251057 N6999RWorswick Dwight D · Yuba City, CAS/N 17251549 N701VPMead Donald W · Butte Meadows, CABuilt 1964 · S/N 17251372 N702VPCaribbean Air Partners LLC · Winter Garden, FLBuilt 1964 · S/N 17251373 N703VPCaribbean Air Partners LLC · Winter Garden, FLBuilt 1963 · S/N 17250823 N708RFHilton Charles Larry · Arcadia, FLBuilt 1964 · S/N 17250695 N718DFTurning Point @ Sonrise Inc · Hartsville, TNBuilt 1964 · S/N 17251190 N724CTWarner David A · Carbondale, ILBuilt 1963 · S/N 17251105 N7700UJarvis Tree Service Inc · Heber Springs, ARBuilt 1964 · S/N 17251700 N7701UIyer Sundaresh R · Northborough, MABuilt 1964 · S/N 17251701 N7705UCaldwell Evan-James Gray · Camano Island, WAS/N 17251705 N7707UMeese Brian D · Conroe, TXBuilt 1964 · S/N 17251707 N7708UDahle Jacob J · Morristown, MNBuilt 1964 · S/N 17251708 N7711UHaneline Douglas A II · Statesville, NCFirst renewal noticeS/N 17251711

Back to Cessna 172E