Skip to content

Registered aircraft · 3,138

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

N4698DDrm Aviation LLC · Glencoe, ALBuilt 1979 · S/N 17272333 N4702FSouthern Aces LLC · Geneva, FLBuilt 1979 · S/N 17273074 N4704GRegistration Pending · Spencerville, OHRegistration pendingS/N 17273326 N4705DN4705d LLC · Oklahoma City, OKS/N 17272335 N4706DKelly William W · Springfield, ORBuilt 1979 · S/N 17272336 N4714FHastings Stephen J · Palmer, AKS/N 17273075 N4715JClarke Brent H · Neversink, NYS/N 17273666 N4719FFrederick Joel · Hobe Sound, FLBuilt 1979 · S/N 17273076 N4725DClover Park Technical College · Tacoma, WABuilt 1979 · S/N 17272340 N4725GRegistration Pending · Tampa, FLRegistration pendingS/N 17273330 N4726GAckerman Timothy M · Barnesville, OHS/N 17273331 N4727D4 Leaf Clover Leasing LLC · Murrieta, CABuilt 1979 · S/N 17272341 N4727GDelaney Patrick · Marion, TXS/N 17273332 N4728GHidalgo Ciro R · Granbury, TXS/N 17273333 N4733DWycoff Shannon M · Baton Rouge, LABuilt 1979 · S/N 17272344 N4738GCmk Aerial Inc · Sutton, NES/N 17273335 N4739DMuddy Creek Aviation LLC · Dayton, VAS/N 17272346 N4739JVero Technical Support Inc · Pensacola, FLBuilt 1979 · S/N 17273672 N4744GJackson Flight Center LLC · Moses Lake, WABuilt 1979 · S/N 17273336 N4748JYecny Enterprises Inc DBA · San Luis Obispo, CAFirst renewal noticeBuilt 1979 · S/N 17273673 N4751GJeff Air Pilot Services LLC · Shelbyville, INS/N 17273337 N4757DCalhoun Gerrald E · Leesburg, FLS/N 17272352 N4759GSanders Flight Training Center Inc · Jasper, ALS/N 17273341 N4763DRandolph Terrence · Bowie, MDBuilt 1979 · S/N 17272354 N4764DQuadrelec Engineering Corp · Tulsa, OKBuilt 1979 · S/N 17272355 N47657Dallam Pat M · Cool, CABuilt 1979 · S/N 17271962 N4768EEagle Aviation Inc · Tucson, AZBuilt 1978 · S/N 17271633 N4772EDrost Larry L · Charlevoix, MIBuilt 1978 · S/N 17271637 N4774EZhao Dan · New York, NYBuilt 1978 · S/N 17271639 N4774FIlmberger Stephen J · Bend, ORBuilt 1979 · S/N 17273079 N4775DHetrick-Price Willow · Anchorage, AKBuilt 1979 · S/N 17272357 N4776EAlpha One Aviation LLC · Dunedin, FLBuilt 1978 · S/N 17271641 N4778EClemmons Flyers LLC · Green Cove Springs, FLS/N 17271643 N4780ECarolinas Aviation LLC · North Myrtle Beach, SCBuilt 1978 · S/N 17271645 N4784EPeabody Jeffery L · Vinemont, ALBuilt 1978 · S/N 17271649 N4786ETu Erik S · Pasadena, CABuilt 1978 · S/N 17271651 N4787ESilverhawk Aviation Academy LLC · Caldwell, IDBuilt 1978 · S/N 17271652 N4788DJb Aviation Flight School Inc · Wonder Lake, ILBuilt 1979 · S/N 17272359 N4788ETiernan Jeffery P · Waddington, NYBuilt 1978 · S/N 17271653 N4789DStevens Dennis W · Mohave Valley, AZBuilt 1979 · S/N 17272360 N4789EPhil Weber Investments LLC · San Diego, CABuilt 1978 · S/N 17271654 N4789GCrossflot Aviation Inc · Shepherdstown, WVBuilt 1979 · S/N 17273343 N4790EMahon Enterprises LLC · Gray Court, SCBuilt 1979 · S/N 17271655 N4790GWings Over Texas Holdings LLC · Denton, TXS/N 17273344 N4790JAmanzi LLC · Brasstown, NCFirst renewal noticeBuilt 1979 · S/N 17273677 N4791EMelbourne Flight Training LLC · Melbourne, FLBuilt 1978 · S/N 17271656 N4793EKillpack Kevin R · Rio Rancho, NMBuilt 1978 · S/N 17271658 N4793FCitizen Air LLC · Port Angeles, WABuilt 1980 · S/N 17273081 N4798EClark Robert · Junction City, KSBuilt 1978 · S/N 17271663 N4800GPavco Inc · Gig Harbor, WAS/N 17273348

Back to Cessna 172N