Skip to content

Registered aircraft · 857

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

N7142QObymachow Richard M · Killingworth, CTS/N 17260442 N7146QPressley Aviation LLC · New London, NCBuilt 1972 · S/N 17260446 N7149QS&H Aviation LLC · Columbus, INS/N 17260449 N7152QSkyrealms LLC · Austin, TXBuilt 1972 · S/N 17260452 N7155QValley Ltd Of Fayetteville · Fayetteville, NCBuilt 1972 · S/N 17260455 N7156QAmerican Patrols Inc · Midland, TXBuilt 1972 · S/N 17260456 N7160QPhoenix Aviation LLC · Meridian, IDBuilt 1972 · S/N 17260460 N7161QFrigate Aviation LLC · Smithville, OHBuilt 1972 · S/N 17260461 N7171QMcnamara Bradley W · Seattle, WABuilt 1972 · S/N 17260471 N7172QRounds Agronomy LLC · Pierre, SDS/N 17260472 N7173QWesterly Av Group LLC · Westerly, RIS/N 17260473 N7176QJax Beach Aviation LLC · Jacksonville, FLBuilt 1972 · S/N 17260476 N7177QLeonard William K · Seattle, WABuilt 1972 · S/N 17260477 N7178QSkylens LLC · Hammond, LABuilt 1972 · S/N 17260478 N7183QFlying Wild LLC · Yarmouth, MEBuilt 1972 · S/N 17260483 N7187QChestnut Ridge Flying Club · Latrobe, PABuilt 1972 · S/N 17260487 N7188QToles Chad · Austin, TXFirst renewal noticeBuilt 1972 · S/N 17260488 N7189QMontgomery Paul · Fredericksburg, VABuilt 1972 · S/N 17260489 N7192QMansfield Heliflight Inc · Milton, VTBuilt 1972 · S/N 17260492 N7194QOzarks Auto Show Inc · Hollister, MOBuilt 1973 · S/N 17260494 N7195QPuget Sound Flyers · Everett, WABuilt 1972 · S/N 17260495 N7196QBurdis W J · Beaver Falls, PABuilt 1972 · S/N 17260496 N7198QBay Lux Ventures LLC · Tampa, FLBuilt 1972 · S/N 17260498 N71HHEastern Slope Aviation Academy · North Conway, NHBuilt 1971 · S/N 17260295 N7200QFisher Eric C · San Francisco, CABuilt 1972 · S/N 17260500 N7204QTexas Air Rangers LLC · Mckinney, TXBuilt 1972 · S/N 17260504 N7205QN7205q LLC · Titusville, FLBuilt 1972 · S/N 17260505 N7206QN7206q LLC · Myrtle Beach, SCBuilt 1972 · S/N 17260506 N7207QMountain Peaks Aviation LLC · Clancy, MTBuilt 1972 · S/N 17260507 N7209QKimble Leon · Rocky Hill, CTBuilt 1972 · S/N 17260509 N7210QAthol Orange Aero Club Inc · Athol, MABuilt 1972 · S/N 17260510 N7212QLink Air Service LLC · Minong, WIBuilt 1972 · S/N 17260512 N7213QChain O Lakes Flying Club & Co Inc · Waupaca, WIBuilt 1972 · S/N 17260513 N7215QRhynette Airways LLC · Key Largo, FLBuilt 1972 · S/N 17260515 N7216QElias Close Deanna · Kenilworth, ILBuilt 1972 · S/N 17260516 N7217QRegistration Pending · Fond Du Lac, WIRegistration pendingS/N 17260517 N7221QSleeping Giant Flying Club · Helena, MTBuilt 1972 · S/N 17260521 N7222QMohawk Flying Club Inc · Ada, MIBuilt 1972 · S/N 17260522 N7223QBuiqui Aerospace Corp · Kissimmee, FLBuilt 1972 · S/N 17260523 N7227QElite Air LLC · Tullahoma, TNBuilt 1972 · S/N 17260527 N7229QSwitzer Frank Jr · Port Allegany, PABuilt 1972 · S/N 17260529 N7230QArcade Flying Club Inc · El Dorado Hills, CABuilt 1972 · S/N 17260530 N7231QDsr-Cherokee 180 LLC · Dallas, TXS/N 17260531 N7234QLavinio Stephen E · Southampton, NYBuilt 1972 · S/N 17260534 N7236QTeren Nelson F · Friday Harbor, WABuilt 1972 · S/N 17260536 N7237QMartin Bach Aviation LLC · Cornelius, NCBuilt 1972 · S/N 17260537 N7244QBuckley Gregory L · Melba, IDS/N 17260544 N7246QHaines Anne K · Ligonier, PABuilt 1972 · S/N 17260546 N7248QEricson Steven L · Dorris, CABuilt 1972 · S/N 17260548 N7249QTrailgate Tailgate Systems Inc · Belle Vernon, PABuilt 1972 · S/N 17260549

Back to Cessna 172L