Skip to content

Registered aircraft · 445

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

N6185RSkywalker Ranch LLC · Dover, DEBuilt 1979 · S/N 172RG0108 N6190RSundance Flying Club Inc · Palo Alto, CABuilt 1979 · S/N 172RG0110 N6200RFlycarolina LLC · Charlotte, NCBuilt 1979 · S/N 172RG0112 N6205VRed Baron LLC · Middletown, DEBuilt 1980 · S/N 172RG0590 N6212RPliego M Guillermo M · Corpus Christi, TXS/N 172RG0117 N6216RRegistered aircraftBuilt 1979 · S/N 172RG0119 N621DCResource Extension LLC · Jupiter, FLBuilt 1980 · S/N 172RG0756 N6223VAxis Aviation LLC · Bloomingdale, GABuilt 1980 · S/N 172RG0593 N6225RHartman Michael F · Montclair, CABuilt 1979 · S/N 172RG0122 N6249VN6249v LLC · Park Ridge, ILBuilt 1980 · S/N 172RG0596 N6254VVector Air Inc · Oklahoma City, OKBuilt 1980 · S/N 172RG0597 N6266VSix Pack Aviation LLC · Pocono Pines, PABuilt 1980 · S/N 172RG0601 N626AFCape Fear Pilots LLC · Bald Head Island, NCBuilt 1980 · S/N 172RG0390 N6270RAbout Time Aviation · Springfield, ORBuilt 1979 · S/N 172RG0132 N6274VDollbaum Robert A · Southfields, NYBuilt 1980 · S/N 172RG0604 N6275RFoode Frank J · Cordova, AKBuilt 1979 · S/N 172RG0137 N6278RCress LLC · Dover, DEBuilt 1979 · S/N 172RG0139 N6279VRegistered aircraftBuilt 1980 · S/N 172RG0605 N6280RBredvold Daniel M · Mendota Heights, MNBuilt 1979 · S/N 172RG0141 N6280VHenneberry Joseph Paul III · Pilot Hill, CABuilt 1980 · S/N 172RG0606 N6283VAxley Micheal S · Portland, ORBuilt 1980 · S/N 172RG0608 N6284RTop Aircraft Leasing LLC · Wilmington, DEBuilt 1979 · S/N 172RG0144 N6290VDelta Sierra Aviation LLC · White Salmon, WABuilt 1980 · S/N 172RG0610 N6292RHynes Kevin P · Wichita Falls, TXBuilt 1979 · S/N 172RG0152 N6294RMitrenko Alexander V · Selinsgrove, PABuilt 1979 · S/N 172RG0154 N6308RIngalls Randy · Alexandria, LABuilt 1979 · S/N 172RG0159 N6309VHamilton Paul L · Arlington, VABuilt 1980 · S/N 172RG0617 N6320RGehr Garner J · Eustis, FLS/N 172RG0163 N6330VLegacy Lsa LLC · Lubbock, TXS/N 172RG0628 N6336VKman LLC · Kalispell, MTBuilt 1980 · S/N 172RG0632 N6337VFirelight Ventures LLC · Fuquay Varina, NCBuilt 1980 · S/N 172RG0633 N6345VBas Part Sales LLC · Greeley, COBuilt 1980 · S/N 172RG0636 N6346VPierobon Luciano I · Port Orange, FLBuilt 1980 · S/N 172RG0637 N6352VMiles Richard A · Macon, NCBuilt 1980 · S/N 172RG0640 N6386VSaunders Andreas · Wake Forest, NCS/N 172RG0649 N6393RGilbert John · Austin, TXBuilt 1979 · S/N 172RG0176 N6394VRice Aviation · Maddock, NDBuilt 1980 · S/N 172RG0656 N6397VSale Reported · Tucson, AZSale reportedBuilt 1980 · S/N 172RG0659 N6399VBrim Janie J · Auburn, WAS/N 172RG0661 N6400VFearon Kenneth M · Sidney, OHBuilt 1980 · S/N 172RG0662 N6401VGdl Aviation LLC · Lincoln, NEBuilt 1980 · S/N 172RG0663 N6402VG&M Aircraft Inc · Wheat Ridge, COBuilt 1980 · S/N 172RG0664 N6403VVista Aviation Inc · Pacoima, CABuilt 1980 · S/N 172RG0665 N6407VWard Matthew A · Fort Worth, TXBuilt 1980 · S/N 172RG0669 N6410VEckerle Christopher K · San Bruno, CABuilt 1980 · S/N 172RG0672 N6411VSouth Air Aviation LLC · Miami, FLBuilt 1980 · S/N 172RG0673 N6415RAlpine Aviation Of Fayetteville Inc · Prairie Grove, ARBuilt 1979 · S/N 172RG0179 N6415VPeter Prince Aviation Center LLC · Milton, FLS/N 172RG0677 N6419VUrbana Aircraft LLC · Urbana, MDBuilt 1980 · S/N 172RG0680 N6420VKorson James · Yorkville, ILBuilt 1980 · S/N 172RG0681

Back to Cessna 172RG