Skip to content

Registered aircraft · 423

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

N8551SOpticalx LLC · Tracy, CAS/N 18256651 N8552SRtd Farm Inc · Fort Benton, MTBuilt 1965 · S/N 18256652 N8555SBray Harvey G · Reidsville, NCBuilt 1965 · S/N 18256655 N8556SRoyalty Marshall E · Seymour, INBuilt 1965 · S/N 18256656 N8557SLittle River Aviation LLC · Tifton, GABuilt 1965 · S/N 18256657 N8559SHanson Robert J · Renton, WABuilt 1965 · S/N 18256659 N8566SVon Borstel Alan W · Grass Valley, ORBuilt 1965 · S/N 18256666 N8571SStevenson Intermountain Seed Inc · Ephraim, UTBuilt 1965 · S/N 18256671 N8572SPaulan Beverly S · Antioch, ILBuilt 1965 · S/N 18256672 N8573S182 Flight Corp · Bronx, NYBuilt 1965 · S/N 18256673 N8575SDallas William J · Eastsound, WABuilt 1965 · S/N 18256675 N8577SRegistration Pending · Concord, GARegistration pendingBuilt 1965 · S/N 18256677 N8579SHopp Gregory R · Columbus, OHBuilt 1965 · S/N 18256679 N8581SBlack Samuel W · Kennesaw, GABuilt 1965 · S/N 18256681 N8583SDevillier Roland James · Winnie, TXBuilt 1965 · S/N 18256683 N8584SRider Richard Trustee · Mill Valley, CABuilt 1965 · S/N 18256684 N860XWiebelhaus John J · Strasburg, COBuilt 1965 · S/N 18256096 N881PBDiffenderfer Paul A · Peachtree City, GABuilt 1965 · S/N 18256607 N899PPT&M Air Az LLC · Phoenix, AZBuilt 1964 · S/N 18255946 N90VABg Construction Consulting LLC · Denver, COBuilt 1965 · S/N 18256598 N940WSkyhawks Inc · Westminster, COBuilt 1965 · S/N 18256606 N94HDFreed Philip B · Parkland, FLBuilt 1965 · S/N 18256368 N9RLKrug Heath · Colusa, CABuilt 1964 · S/N 18255986

Back to Cessna 182H