Skip to content

Registered aircraft · 435

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

N7853TBailey Ned A · Friday Harbor, WABuilt 1960 · S/N 47453 N7857TDiamondhead Aero Co-Owners LLC · Picayune, MSBuilt 1960 · S/N 47457 N7861TKepo Aviation LLC · Ball, LABuilt 1960 · S/N 47461 N7863TNelson Scott J · Saline, MIBuilt 1960 · S/N 47463 N7865TN7865t LLC · Key West, FLBuilt 1960 · S/N 47465 N7869THelms Brett · Valley Center, CABuilt 1960 · S/N 47469 N7871TPeters Harold B · Weirsdale, FLBuilt 1960 · S/N 47471 N7874TReisinger Thomas P · Browerville, MNS/N 47474 N7876TRoberts Gary W · Friday Harbor, WABuilt 1960 · S/N 47476 N7880THaskins Matthew D · Muskegon, MIBuilt 1960 · S/N 47480 N7884THyde Russell M · Rutherfordton, NCBuilt 1960 · S/N 47484 N7885TSmith William B · Marcola, ORBuilt 1960 · S/N 47485 N7886TCobb John R · Boynton Beach, FLBuilt 1960 · S/N 47486 N7888TMyers Jay R · Delavan, WIS/N 47488 N7891TDonaldson Robert M · San Ramon, CABuilt 1960 · S/N 47491 N7894TGriggs Howard D · Crestline, CABuilt 1960 · S/N 47494 N7897TFunk Kenneth E · Warner Robins, GABuilt 1960 · S/N 47497 N8953TDouglass Jason E · Friday Harbor, WABuilt 1959 · S/N 47158 N95GCGrant James T · Huntsville, ALBuilt 1960 · S/N 47386 N96RRDocter David Alan · New Braunfels, TXBuilt 1959 · S/N 47025 N9702TStricklin Lance A · Fort Greely, AKS/N 47502 N9703TBlock Douglas · Pearl City, ILBuilt 1960 · S/N 47503 N9706TStoddard Micah J · Boise, IDBuilt 1960 · S/N 47506 N9710TTrzynka Dean A · Iron River, WIBuilt 1960 · S/N 47510 N9722TFoust Richard W · Minneapolis, KSBuilt 1960 · S/N 47522 N9723TLuinstra Lee Vernon · Benton, KSBuilt 1960 · S/N 47523 N9725TAnderas Per R · Green Bay, WIS/N 47525 N9726TBuettner Casey R · Kearney, NES/N 47526 N9727TRogers Bob · Mountain Green, UTBuilt 1960 · S/N 47527 N9728TBanks Trevor A · Thomaston, GABuilt 1960 · S/N 47528 N9729TGibbs David F · Greenville, NCBuilt 1960 · S/N 47529 N9731TKarren Robert E · Mountain Home, IDS/N 47531 N9745TOwens Edward W · Raymore, MOBuilt 1960 · S/N 47545 N9747TMapes James R · Ellensburg, WABuilt 1960 · S/N 47547 N9751TAbles Marlan L · Carthage, ARBuilt 1960 · S/N 47551 N9753TCowan Ronnie C · Glasgow, KYS/N 47553 N9779THill Kevin D · Port Lavaca, TXBuilt 1960 · S/N 47579 N9780TGilbert Tanner A · Midland, TXS/N 47580 N9781TPacheco James S · West Ossipee, NHBuilt 1960 · S/N 47581 N9782TFascenda Matthew Roman · Mint Hill, NCBuilt 1960 · S/N 47582 N9787TMapes Peter B · Oscoda, MIBuilt 1960 · S/N 47587 N9795TWhite Cap Aviation LLC · Amsterdam, NYS/N 47595 N9797TBasham James L · Livingston, TXS/N 47597 N9798TRegistered aircraftBuilt 1960 · S/N 47598 N9799TDeapen Jordan Derek · Clifton, TXBuilt 1960 · S/N 47599 N9800THerr Garrick D · Wasilla, AKBuilt 1960 · S/N 47600 N9802TSandford Graves M · Moberly, MOS/N 47602 N9804TRussell Michael K · Sprakers, NYBuilt 1960 · S/N 47604 N9805TNorman Ronald E · Lopez Island, WABuilt 1960 · S/N 47605 N9808TGilmer Randy G · Nickelsville, VABuilt 1960 · S/N 47608

Back to Cessna 172A