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.

N15AFRogers Jeff · Harrogate, TNBuilt 1976 · S/N 17267237 N1602VRegistration Pending · Lucas, TXRegistration pendingBuilt 1974 · S/N 17263690 N1613VMcewen Michael A M D · Gadsden, ALBuilt 1974 · S/N 17263692 N1615VFrance Jeffrey A · Reedville, VABuilt 1974 · S/N 17263693 N1617VCook Timothy D · Ashville, NYBuilt 1974 · S/N 17263694 N1660VOdegaard Wings Inc · Kindred, NDBuilt 1974 · S/N 17263705 N1664VBismarck Aero Center Corp · Bismarck, NDBuilt 1974 · S/N 17263706 N1666VSkypark Inc · Wadsworth, OHBuilt 1974 · S/N 17263707 N1674VAbraham Elizabeth J · Browntown, WIBuilt 1974 · S/N 17263709 N1688VAvstem Incorporated · Mc Grath, AKBuilt 1974 · S/N 17263714 N169HCButterfly Wings Of Miami LLC · Miramar, FLBuilt 1973 · S/N 17262693 N16EKCenterline Holdings LLC · Belgrade, MTBuilt 1975 · S/N 17265927 N1701VBeach Chad T · Kilgore, TXBuilt 1974 · S/N 17262851 N1702VClassic Rotors Museum · Ramona, CABuilt 1974 · S/N 17263717 N1705VNiles Air LLC · Concord, NCBuilt 1974 · S/N 17263718 N1713VGrasshopper Flying Club · Poughkeepsie, NYBuilt 1974 · S/N 17263721 N1723VRay Alan G · Oklahoma City, OKS/N 17263725 N172AMYang Chi · Lafayette, COBuilt 1975 · S/N 17264993 N172APBmac Aviation LLC · Dallas, TXBuilt 1976 · S/N 17266592 N172ARStraub Cordaro · Monterey, CABuilt 1975 · S/N 17266174 N172BKUsaeroflight LLC · Greenville, SCBuilt 1976 · S/N 17267323 N172BLMullinax Donald D · Graham, WABuilt 1974 · S/N 17262050 N172BROc Flight Lessons LLC · Costa Mesa, CABuilt 1975 · S/N 17265776 N172CGWings Over Texas Holdings LLC · Denton, TXBuilt 1975 · S/N 17264991 N172CWGoddard William W · Apple Valley, CABuilt 1974 · S/N 17263325 N172DLKling Aviation Inc · Friendswood, TXBuilt 1975 · S/N 17266166 N172DSJb Air Services LLC · Framingham, MABuilt 1975 · S/N 17265198 N172EPlymouth Flying Club Inc · Plymouth, NHBuilt 1974 · S/N 17263335 N172EBMiller David A · Kodiak, AKBuilt 1973 · S/N 17261560 N172ECNilo Aviation LLC · Arley, ALBuilt 1976 · S/N 17266723 N172EMUnited States Aviation Consultants LLC · Davie, FLS/N 17267336 N172EQSpeck Richard G · Wilmington, DEBuilt 1973 · S/N 17262251 N172EWWoodrum Stephen D · Mesa, AZBuilt 1975 · S/N 17265167 N172GMWings Over Texas Holdings LLC · Denton, TXBuilt 1976 · S/N 17267127 N172GRN172gr LLC · Tamarac, FLBuilt 1973 · S/N 17261991 N172HDSchadt Andrew M · Edwardsville, ILBuilt 1976 · S/N 17267191 N172HFBuiqui Aerospace Corp · Kissimmee, FLS/N 17264634 N172JBWood Jonathan R · Sedgwick, MEBuilt 1973 · S/N 17262206 N172JDBlack Hound Aviation LLC · Austin, TXBuilt 1974 · S/N 17263844 N172JJFort Leavenworth Flying Activity · Fort Leavenworth, KSBuilt 1975 · S/N 17265488 N172JMCardinal Wings Aviation LLC · Buckner, KYS/N 17262202 N172KDKad Aviation LLC · Athens, ALBuilt 1976 · S/N 17267467 N172KYAir Dogs LLC · Mount Washington, KYBuilt 1975 · S/N 17266093 N172LCIfly Aviation LLC · Conway, ARBuilt 1974 · S/N 17263219 N172LGPolk Brandon A · Valrico, FLBuilt 1974 · S/N 17264203 N172LJN W Aviators Inc · Troutdale, ORBuilt 1975 · S/N 17266242 N172MC172 Mikecharlie LLC · Ocala, FLBuilt 1975 · S/N 17265980 N172MDDc Aerial Photos Inc · Fredericksburg, VABuilt 1974 · S/N 17263421 N172MEBlue Ridge Airworks LLC · Charlottesville, VABuilt 1974 · S/N 17263996 N172MKRivera Glauco A · Isabela, PRBuilt 1976 · S/N 17266714

Back to Cessna 172M