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.

N4861GFlying Colors Airparts Inc · Leesburg, FLBuilt 1979 · S/N 17273408 N4864DChiota Aviation LLC · Waco, TXFirst renewal noticeBuilt 1979 · S/N 17272377 N4864GLazy Eights Holdings LLC · Greenwood, INBuilt 1979 · S/N 17273411 N4865DBlack Hound Aviation LLC · Austin, TXS/N 17273904 N4867DFlynn Brian · Auburndale, FLBuilt 1979 · S/N 17272378 N4868EVero Technical Support Inc · Pensacola, FLBuilt 1978 · S/N 17271671 N4870DSherman Hess M · Poplar Grove, ILBuilt 1979 · S/N 17272379 N4870GCal Aggie Flying Farmers Inc · Davis, CABuilt 1979 · S/N 17273417 N4872DPs N4872d LLC · Green Bay, WIBuilt 1979 · S/N 17272381 N4873G4873g Flying Club Inc · Punxsutawney, PABuilt 1979 · S/N 17273420 N4876FCosta Air Service LLC · Painted Post, NYBuilt 1979 · S/N 17273094 N4876GKing Bryan A · Austin, TXBuilt 1979 · S/N 17273423 N4877DAviator Air Flight School LLC · Grand Prairie, TXBuilt 1979 · S/N 17272383 N4877JR&R Aero Services LLC · Eden Prairie, MNBuilt 1979 · S/N 17273687 N4879DMorey Airplane Company Inc · Middleton, WIBuilt 1979 · S/N 17272384 N4880FFkm Air Shuttle LLC · Brooklyn, NYBuilt 1979 · S/N 17273095 N4880GCifelli George J · Dothan, ALFirst renewal noticeBuilt 1979 · S/N 17273427 N4881EFulltron Aviation LLC · Springfield, MOBuilt 1978 · S/N 17271672 N4883GPlane Nuts Aviation LLC · Livingston, LABuilt 1979 · S/N 17273430 N4885DSpartan National Holdings LLC · Missoula, MTBuilt 1979 · S/N 17272386 N4885GS&P Aviation LLC · Albuquerque, NMS/N 17273432 N4886GSkycrafters Inc · Johnson City, TNFirst renewal noticeBuilt 1979 · S/N 17273433 N4887GSouthern Aero LLC · Homestead, FLBuilt 1979 · S/N 17273434 N4888G578 Airplane Leasing Inc · Kissimmee, FLS/N 17273435 N4889DPink Skies Inc · Willoughby, OHBuilt 1979 · S/N 17272387 N4889GKittitas Aero Inc · Kittitas, WABuilt 1979 · S/N 17273436 N488BAPlane Nonsense Inc · Middletown, DES/N 17273345 N4891JHarris Aircraft Leasing Co · Oklahoma City, OKBuilt 1979 · S/N 17273691 N4893ELjl & D Inc · Wilmington, DEBuilt 1978 · S/N 17271673 N4893GBoldflight LLC · Greenwood, INBuilt 1979 · S/N 17273440 N4893JMartineau Aircraft Inc · Butte, MTBuilt 1979 · S/N 17273692 N4895GWilson Forest B · Hollister, CABuilt 1979 · S/N 17273442 N4896GGecha Richard Mike · Florence, VTBuilt 1979 · S/N 17273443 N4897ESig Flights LLC · Hickory, NCBuilt 1978 · S/N 17271674 N4897GWings Over Texas Holdings LLC · Denton, TXBuilt 1979 · S/N 17273444 N4898FLima-001 LLC · Muscatine, IABuilt 1979 · S/N 17273097 N4899GJf Property Leasing Inc · Port Orchard, WAS/N 17273446 N489ERMenefee Scott A · Los Banos, CABuilt 1978 · S/N 17272083 N48BGWhitfill Mark J · Crockett, TXBuilt 1978 · S/N 17271064 N4900DCastaneda Jose · Yakima, WAS/N 17272389 N4902FFlying Vikings Inc · Hayward, CABuilt 1979 · S/N 17273099 N4904GC & W Aviation LLC · Trumbull, CTBuilt 1979 · S/N 17273451 N4908GShaffer Aviation LLC · Tupelo, MSS/N 17273455 N4909GRed Arrow Aviation LLC · Santa Teresa, NMBuilt 1979 · S/N 17273456 N4910DN4910d LLC · Delavan, WIBuilt 1979 · S/N 17272394 N4912GHardee Christopher D · Smyrna, TNBuilt 1979 · S/N 17273459 N4913DRosies Procurement LLC · Midlothian, TXBuilt 1979 · S/N 17272395 N4913GLeading Edge Flight Academy LLC · Bend, ORBuilt 1979 · S/N 17273460 N4916GOngstad Anne Whitman · Robinson, NDBuilt 1979 · S/N 17273463 N4917GCarter Richard W · Bumpass, VABuilt 1979 · S/N 17273464

Back to Cessna 172N