Skip to content

Registered aircraft · 857

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

N7250QSale Reported · Crystal, MNSale reported, pending cancellationBuilt 1972 · S/N 17260550 N7251QGarcia Crystal M · Brownsville, ORBuilt 1972 · S/N 17260551 N7252QRobbins Aviation LLC · Scottsbluff, NEBuilt 1972 · S/N 17260552 N7253QHarry'S Hawks · Wells, MNBuilt 1972 · S/N 17260553 N7254QRegistration Pending · Phoenix, AZRegistration pendingBuilt 1972 · S/N 17260554 N7255QSierra Sky Aviation LLC · Kalispell, MTS/N 17260555 N7257QSmith Henry C III · Essexville, MIBuilt 1972 · S/N 17260557 N7259QForbes Gregory Allan · Lowell, MIBuilt 1972 · S/N 17260559 N725BKAmerican Patrols Inc · Midland, TXBuilt 1971 · S/N 17259821 N725RJWilliams Sol F · Jacksonville, FLBuilt 1971 · S/N 17260254 N7261QSchilling Aviation Services LLC · Salina, KSS/N 17260561 N7262QFlikins Barbara L · Fillmore, CABuilt 1972 · S/N 17260562 N7263QWyatt Barbara Louise · Cheyenne, WYBuilt 1972 · S/N 17260563 N7264QAdams Rick B · Ashford, WABuilt 1972 · S/N 17260564 N7266QLima-001 LLC · Muscatine, IABuilt 1972 · S/N 17260566 N7269QBaker Mark · White Bear Lake, MNBuilt 1972 · S/N 17260569 N7286QLacombe Bryan K · Rockwall, TXBuilt 1972 · S/N 17260586 N7288QAerosmith Aviation LLC · Marietta, GAFirst renewal noticeS/N 17260588 N7292QDevereaux Bruce O · Pewamo, MIBuilt 1972 · S/N 17260592 N7295QKangas Lisa M · Fairbanks, AKS/N 17260595 N7296QRich Aviation Services LLC · Fort Worth, TXBuilt 1972 · S/N 17260596 N7299QStout Oscar M · Brookshire, TXS/N 17260599 N73PWWarren John M · El Paso, TXBuilt 1971 · S/N 17259809 N747GBBrogan Kenneth A Jr · Montesano, WABuilt 1972 · S/N 17259440 N747LPSimplifly LLC · Mesa, AZBuilt 1971 · S/N 17260272 N7524GBrandywine Sky Ramblers LLC · West Chester, PABuilt 1970 · S/N 17259224 N7526GFoothill Aircraft Sales & Service Inc · Upland, CABuilt 1970 · S/N 17259226 N7528GSale Reported · Rillito, AZSale reported, pending cancellationBuilt 1970 · S/N 17259228 N7540GKelley Aircraft LLC · Weyers Cave, VABuilt 1970 · S/N 17259240 N7542GNelson Frank H · Tuscaloosa, ALBuilt 1970 · S/N 17259242 N7543GTrue Course LLC · West Monroe, NYBuilt 1970 · S/N 17259243 N7547GMutter William D · Chelan, WABuilt 1970 · S/N 17259247 N7548GRetro Modern Aviation LLC · Manitou Springs, COBuilt 1970 · S/N 17259248 N7550G7550g LLC · Birmingham, MIBuilt 1970 · S/N 17259250 N7551GNb Airdoc LLC · Aventura, FLBuilt 1970 · S/N 17259251 N7555GSac Air LLC · Citrus Heights, CABuilt 1970 · S/N 17259255 N7556GWetlesen Gabriel C · Palmer, AKBuilt 1970 · S/N 17259256 N7557GLe Gros Donald P · Jennings, LABuilt 1970 · S/N 17259257 N7558GKessler Garry A · Lansing, WVS/N 17259258 N7559GLopez Johnny · Henderson, NVBuilt 1970 · S/N 17259259 N7561GNextgen Flight Academy Inc · Riverside, CABuilt 1970 · S/N 17259261 N7562GWings Over Texas Holdings LLC · Denton, TXS/N 17259262 N7563GOso Air LLC · Missoula, MTS/N 17259263 N7564GRegistration Pending · Sterling, AKRegistration pendingBuilt 1970 · S/N 17259264 N7565GB&R Aircraft LLC · Wadsworth, OHBuilt 1970 · S/N 17259265 N7567GWhipple Eugene B · Mchenry, ILBuilt 1970 · S/N 17259267 N7569GAirborne LLC · Wilmington, DEBuilt 1970 · S/N 17259269 N7571GCook Thomas B · Boston, MABuilt 1970 · S/N 17259271 N7573GBecker Todd J · Arlington, NEBuilt 1970 · S/N 17259273 N7575GKelley Aircraft LLC · Weyers Cave, VABuilt 1970 · S/N 17259275

Back to Cessna 172L