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.

N5202JLizco Aviation LLC · Jackson, MOBuilt 1980 · S/N 17273729 N5203DAcumen Aerotech LLC · Rogers, TXBuilt 1979 · S/N 17272446 N5205DAlleghany Flying Club Inc · Hyndman, PABuilt 1979 · S/N 17272448 N5208DVarsity Flight Ops LLC · Las Vegas, NVBuilt 1979 · S/N 17272451 N5208JFly Dreams Aircraft Group Inc · Fort Lauderdale, FLBuilt 1980 · S/N 17273732 N5210FSloan Nathan S · Owensboro, KYBuilt 1979 · S/N 17273128 N5212EFinley Bryce · Sandy, UTBuilt 1978 · S/N 17271772 N5215DAviation Trust Co LLC Trustee · Oklahoma City, OKS/N 17272453 N5215EWifa (Washington International Flight Academy) LLC · Gaithersburg, MDBuilt 1978 · S/N 17271774 N52168Jin Jin Aviation LLC · Anchorage, AKBuilt 1979 · S/N 17273457 N5217DOptima Aviation LLC DBA · Lewisville, TXBuilt 1979 · S/N 17272454 N5218GMarlowe James D · Genoa, OHBuilt 1979 · S/N 17273556 N5219JUpham David E · Madison, WIBuilt 1980 · S/N 17273737 N521LDStar Marianas Air Inc · Tinian, MPBuilt 1977 · S/N 17269184 N5221EAir Capital Aviators Club · Wichita, KSBuilt 1978 · S/N 17271778 N5222DRegistration Pending · Muncie, INRegistration pendingBuilt 1979 · S/N 17272456 N5222JFlywyo LLC · Kalispell, MTBuilt 1980 · S/N 17273738 N5225DMustang Sally Aviation LLC · Camden, SCBuilt 1979 · S/N 17272457 N5226JMcgreen John R · Albany, NYBuilt 1980 · S/N 17273740 N5227DTahoe Arrows LLC · South Lake Tahoe, CABuilt 1979 · S/N 17272458 N5227EAce Of Spades Aviation LLC · Las Vegas, NVS/N 17271782 N5228EMayberry Aviation Inc · Mount Airy, NCBuilt 1978 · S/N 17271783 N5229DMiskell Christopher S · Senoia, GABuilt 1979 · S/N 17272459 N5229EZak Leo P · Oakdale, PABuilt 1978 · S/N 17271784 N5232DVella David A · Scottsboro, ALBuilt 1979 · S/N 17272461 N5233ERichmor Aviation Inc · Hudson, NYBuilt 1978 · S/N 17271786 N5234DWeeks Robert · Lynden, WABuilt 1979 · S/N 17272463 N5239GOverturf Jason · Eureka, MOBuilt 1979 · S/N 17273557 N5240EWilson Brent A · Carmel, INBuilt 1978 · S/N 17271791 N5241DSorbi Aviation Inc · El Cajon, CABuilt 1979 · S/N 17272465 N5241EBaldeo Kessho I · Bay Shore, NYBuilt 1978 · S/N 17271792 N5241JDuffys Aircraft Sales & Leasing Inc · Neillsville, WIBuilt 1980 · S/N 17273743 N5242DR&R Aero Services LLC · Eden Prairie, MNBuilt 1979 · S/N 17272466 N5243ECalifornia Professional Flyers Inc · Murrieta, CABuilt 1978 · S/N 17271793 N5244EOpal Aviation LLC · Athens, GABuilt 1978 · S/N 17271794 N5249DQuicksilver Skycraft LLC · Langley, WAS/N 17272470 N5249EAlexandria Aviation Inc · Alexandria, MNBuilt 1978 · S/N 17271797 N5249JWhitgo LLC · Lucas, TXBuilt 1980 · S/N 17273744 N524BDClark Mark · Captiva, FLBuilt 1979 · S/N 17272180 N5251ERhinelander Flying Service Inc · Rhinelander, WIBuilt 1977 · S/N 17271799 N5254DR&R Aero Services LLC · Eden Prairie, MNBuilt 1979 · S/N 17272473 N5254JWorcester Naa Flying Club · Worcester, MABuilt 1980 · S/N 17273745 N5256DTall Timber Flying Service LLC · Kalispell, MTBuilt 1979 · S/N 17272475 N5260DMeyer Kevin · Hooper, NEBuilt 1979 · S/N 17272478 N5264DPironti Bennett D · Long Valley, NJS/N 17272481 N5265DFly 172rg LLC · Peoria, AZBuilt 1979 · S/N 17272482 N5265ETree Top Flying Service Inc · Clarksville, TNBuilt 1978 · S/N 17271804 N5266DColemanation Investments LLC · Naperville, ILBuilt 1979 · S/N 17272483 N5266ENatchez Flight Training LLC · Natchez, MSBuilt 1978 · S/N 17271805 N5267EBrudelie Alan C · Lewisville, MNBuilt 1978 · S/N 17271806

Back to Cessna 172N