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.

N4919FTice Denzil · Farmville, VABuilt 1979 · S/N 17273102 N4919GRegistration Pending · Fairbanks, AKRegistration pendingS/N 17273466 N4920GEye Candy Aviation LLC · Jacksonville, FLBuilt 1979 · S/N 17273467 N4922DD Gordon Aviation Inc · La Jolla, CABuilt 1979 · S/N 17272398 N4922GBishop Air LLC · Elk Grove, CABuilt 1979 · S/N 17273469 N4923DHarrier Aviation LLC · South Saint Paul, MNBuilt 1979 · S/N 17272399 N4925FA S Air LLC · Lantana, FLBuilt 1979 · S/N 17273103 N4925GSchwenker David W · Queensbury, NYBuilt 1979 · S/N 17273472 N4927DGreenville Flight LLC · Greer, SCS/N 17272401 N4928EAce Of Spades Aviation LLC · Las Vegas, NVBuilt 1978 · S/N 17271676 N492SFSnohomish Flying Service Inc · Snohomish, WABuilt 1976 · S/N 17268310 N492WPAngel Aviation Inc · Peoria, AZBuilt 1979 · S/N 17272684 N4935GKip'S Flying Service LLC · Bankston, ALBuilt 1979 · S/N 17273482 N4937GInternational Air Services Inc Trustee · Carson City, NVBuilt 1979 · S/N 17273484 N4940EFlyright Aviation Inc · North Las Vegas, NVBuilt 1978 · S/N 17271681 N4940GN4940g LLC · Portsmouth, NHS/N 17273487 N4947GRiya Aviation LLC · Tracy, CABuilt 1980 · S/N 17273494 N4948GTrece Inc · Adair, OKS/N 17273495 N4949GFalcon Aviation LLC · South Saint Paul, MNBuilt 1979 · S/N 17273496 N494AMOsprey Holding Company LLC · Foley, ALBuilt 1978 · S/N 17269969 N494WAFly More Inc · Kawkawlin, MIBuilt 1978 · S/N 17271129 N4950DSimpson Darrell W · Soldotna, AKBuilt 1979 · S/N 17272408 N4951GMelbourne Flight Training LLC · Melbourne, FLBuilt 1979 · S/N 17273498 N4952GHighland Rim Aviation LLC · Springfield, TNS/N 17273499 N4953GMcfly LLC · Casper, WYBuilt 1979 · S/N 17273500 N4954GKris Noone Air LLC · Wilmington, DEBuilt 1979 · S/N 17273501 N4955DBerman David M · Charlotte, NCBuilt 1979 · S/N 17272409 N4956DSorbi Aviation Inc · El Cajon, CABuilt 1979 · S/N 17272410 N4961GGardner Clifton T · Vernal, UTBuilt 1979 · S/N 17273508 N4962GVersteeg Martin · San Antonio, TXBuilt 1979 · S/N 17273509 N4963GSunwest Aviation Inc · Santa Ynez, CABuilt 1979 · S/N 17273510 N4964GCrotts Aircraft Service Inc · Dodge City, KSBuilt 1979 · S/N 17273511 N4966GSonger Charles W III · Tuscaloosa, ALBuilt 1979 · S/N 17273513 N4969ECapricorn Equipment Co · Madisonville, KYBuilt 1978 · S/N 17271685 N4969GSanford Aircraft LLC · Winter Springs, FLBuilt 1979 · S/N 17273516 N4971FRegistration Pending · Cottonwood, CARegistration pendingBuilt 1979 · S/N 17273110 N4971GSuper Hawk Inc · West Jordan, UTBuilt 1979 · S/N 17273518 N4972GMcchuck Properties LLC · Pensacola, FLBuilt 1979 · S/N 17273519 N4973FBoraam Aviation Inc · Prospect Heights, ILBuilt 1979 · S/N 17273111 N4974GPea-Wayman Flight LLC · Daytona Beach, FLBuilt 1979 · S/N 17273521 N4975FFg Aviation LLC · La Jolla, CABuilt 1979 · S/N 17273112 N4975GBermuda Dunes Flight Training LLC · Palm Desert, CABuilt 1979 · S/N 17273522 N4976FLytle John A · Anaheim, CABuilt 1980 · S/N 172-73113 N4976GOklahoma Airmen Flying Club Inc · Jenks, OKS/N 17273523 N4978GJin Jin Aviation LLC · Anchorage, AKBuilt 1979 · S/N 17273525 N4981GGillespie John · Austin, TXBuilt 1979 · S/N 17273528 N4982EDevrnja Aero LLC · Knoxville, TNBuilt 1978 · S/N 17271686 N4983FSkyventure Avaition LLC · Battle Creek, MIS/N 17273115 N4983GBrouillard Mark R · Avon, INBuilt 1979 · S/N 17273530 N4994ELaforest David C · Hudson, MIBuilt 1978 · S/N 17271688

Back to Cessna 172N