Skip to content

Registered aircraft · 718

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

N8618UMorgan Ted R · Grant, FLBuilt 1965 · S/N 17252519 N8623UBarry Gehret · Sonoma, CAS/N 17252524 N8624USikora Randall P · Boca Raton, FLBuilt 1965 · S/N 17252525 N8625URubison John R · Shelbina, MOBuilt 1965 · S/N 17252526 N8626UFriedman Arthur M · Santa Paula, CABuilt 1965 · S/N 17252527 N8628UTownsend Slade · Fredonia, TXBuilt 1965 · S/N 17252529 N8629UHedberg Paul D · Atwater, MNBuilt 1965 · S/N 17252530 N8630UOcala Aviation Services Inc · Ocala, FLBuilt 1965 · S/N 17252531 N8636UMls Holdings · Newbury Park, CABuilt 1965 · S/N 17252538 N8638ULittle Kenneth C · Driggs, IDBuilt 1965 · S/N 17252540 N8640USunnyside Aviation Pllc · Theodosia, MOBuilt 1965 · S/N 17252542 N8641UJohnson Jay A · Lisbon, IABuilt 1965 · S/N 17252543 N8644UFung Tak C · Ridge, NYBuilt 1965 · S/N 17252546 N8653UCurtis Heather · Fairbanks, AKBuilt 1965 · S/N 17252555 N8654UThompson George C · Rogersville, ALBuilt 1965 · S/N 17252556 N8657URidley Timothy A · Uniontown, PABuilt 1965 · S/N 17252559 N8660USage Point Ventures LLC · New Harmony, UTS/N 17252562 N8661UBaird Adam D · Salisbury, NCBuilt 1965 · S/N 17252564 N8663USocks Flyers LLC · Southgate, KYS/N 17252566 N8665URathbun Kendrick C · Ocala, FLBuilt 1965 · S/N 17252568 N8666USchultz Mark S · Mokena, ILBuilt 1965 · S/N 17252569 N8667UHillier Ian P · Hummelstown, PABuilt 1965 · S/N 17252570 N8668UGragg Michael W · Newland, NCS/N 17252571 N8670USkyhawk Aviation LLC · Oskaloosa, IAS/N 17252573 N8672UEcho Tango LLC · Milledgeville, GABuilt 1965 · S/N 17252575 N8673UCarpenter Alan B · Wasilla, AKBuilt 1965 · S/N 17252576 N8674UAngle Kevin D · Rocky Mount, VAS/N 17252577 N8677UHunter Richard Louis · Wilton, CABuilt 1965 · S/N 17252580 N8678URoane Aaron J · Ogden, UTBuilt 1965 · S/N 17252581 N8679ULake Aera Technical College · Watertown, SDBuilt 1965 · S/N 17252582 N8680URoberts Robert V · Sebastian, FLBuilt 1965 · S/N 17252583 N8681UFly Around Alaska LLC · Palmer, AKS/N 17252584 N8682UAircraft N8682u Inc · Half Moon Bay, CABuilt 1965 · S/N 17252585 N8683UConrad Richard M · Chinook, MTBuilt 1965 · S/N 17252586 N8684UOlsovsky Jesse C · Bonita Springs, FLBuilt 1965 · S/N 17252587 N8688USabol Andrew R · Waterville, NYBuilt 1965 · S/N 17252592 N8693UCone Randall D · Salida, COBuilt 1965 · S/N 17252597 N8703UNea Construction LLC · Jonesboro, ARBuilt 1965 · S/N 17252607 N8708UDewey William H Trustee · Eugene, ORBuilt 1965 · S/N 17252612 N8709UWilkinson James Richard · Carlsbad, NMBuilt 1965 · S/N 17252613 N8710UDmac Aircraft LLC · Savannah, GABuilt 1965 · S/N 17252614 N8716UWings Of Hope · Chesterfield, MOBuilt 1965 · S/N 17252620 N8718UPuckett Matthew Scott · Argyle, TXBuilt 1965 · S/N 17252622 N8722UBrown Stephen L · Charlotte, MIBuilt 1965 · S/N 172-52626 N8723UTraining Services Inc T/A · Virginia Beach, VABuilt 1965 · S/N 17252627 N8725UArklamiss Aviation LLC · Ruston, LABuilt 1965 · S/N 17252629 N8726UHowell Harley L · Colville, WAS/N 17252630 N8729UEpmeier Bruce E · Newburgh, INBuilt 1965 · S/N 17252633 N8732UHumke John D · Eufaula, OKS/N 17252636 N8734UGrow Aviation LLC · Aurora, NEBuilt 1965 · S/N 17252638

Back to Cessna 172F