Skip to content

Registered aircraft · 1,565

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

N735PYBudrewicz Leo · Stockton, NJBuilt 1977 · S/N 18265588 N735QC7nc1 LLC · Wilmington, NCBuilt 1977 · S/N 18265592 N735QFDrouet D Aubigny Christian · Tucson, AZBuilt 1977 · S/N 18265595 N735QGBarnett Corey · Magnolia, ARBuilt 1977 · S/N 18265596 N735QHMcgraw William B · Punta Gorda, FLBuilt 1977 · S/N 18265597 N735QKClifford Tom · Forsyth, MTBuilt 1977 · S/N 18265599 N735QMGoehring Kevin · Stockton, CABuilt 1977 · S/N 18265601 N735QRLebanon Flying Club Inc · Lebanon, TNBuilt 1977 · S/N 18265605 N735QSRtg Inc · Torrance, CABuilt 1977 · S/N 18265606 N735QWLinderman Kevin M · Washoe Valley, NVBuilt 1977 · S/N 18265610 N735QZPrecision Approach Engineering Inc · Corvallis, ORBuilt 1977 · S/N 18265613 N735RBDouglas Richard E · Wynne, ARBuilt 1977 · S/N 18265615 N735RFProchem Inc · Rockford, ILBuilt 1977 · S/N 18265619 N735RGGilfert Howard C · Mount Laurel, NJBuilt 1977 · S/N 18265620 N735RJ1700 Holdings LLC · Wayzata, MNBuilt 1977 · S/N 18265622 N735RKLegends Air Center LLC · Bentonville, ARBuilt 1977 · S/N 18265623 N735RQMiller Kyle P · Abbott, TXBuilt 1977 · S/N 18265628 N735RSEl Paso Aero Inc · El Paso, TXBuilt 1977 · S/N 18265630 N735RTN735rt LLC · New Berlin, WIBuilt 1977 · S/N 18265631 N735RWGarrett Thomas A · Wilkesboro, NCBuilt 1977 · S/N 18265634 N735RXFelton James Trustee · Canon City, COBuilt 1977 · S/N 18265635 N735SEWedig Enterprises LLC · St George, UTBuilt 1977 · S/N 18265641 N735SGClear Blue Aviation LLC · Hayden, IDBuilt 1977 · S/N 18265643 N735SKGambill Paul G II · Mulberry, ARS/N 18265646 N735SNBorn To Fly LLC · Booker, TXBuilt 1977 · S/N 18265649 N735SPKnapp James A · Casa Grande, AZBuilt 1977 · S/N 18265650 N735SRMoen Ronald C · Spirit Lake, IDBuilt 1977 · S/N 18265652 N735SXParker John S · Houston, TXBuilt 1977 · S/N 18265658 N735TBCarter Joseph J Jr · Lake Wales, FLBuilt 1977 · S/N 18265662 N735TECanir Family Partners Ltd · Port Arthur, TXS/N 18265664 N735TFForeman Gregory M · Sarasota, FLBuilt 1977 · S/N 18265665 N735TKRobinson Larry D · Dewitt, ARBuilt 1977 · S/N 18265669 N735TMHudson Valley Flight Services LLC · Pleasant Valley, NYBuilt 1977 · S/N 18265671 N735TPSailer Jacob J · Menomonie, WIBuilt 1977 · S/N 18265673 N735TRDupre Lynda M · Ligonier, PABuilt 1977 · S/N 18265675 N735TTMadera County Aircrafters · Madera, CAS/N 18265677 N735TUFerguson William R · Sedalia, MOBuilt 1977 · S/N 18265678 N735TVEl Paso Police Department · El Paso, TXBuilt 1977 · S/N 18265679 N735TYSessions John L · Kirbyville, TXS/N 18265682 N735UMonterey Bay Aviation Inc · Watsonville, CAFirst renewal noticeS/N 18265702 N735UAClemens Thomas M · Mount Gretna, PABuilt 1977 · S/N 18265684 N735UBAv8 One LLC · Lewes, DEBuilt 1977 · S/N 18265685 N735UDBleakley Thomas L · Brookhaven, GABuilt 1977 · S/N 18265687 N735UFN735uf LLC · Evans, GABuilt 1977 · S/N 18265689 N735ULStraughn Matthew · Glenn Dale, MDBuilt 1977 · S/N 18265694 N735UPSummitt Aviation LLC · Lake Mary, FLBuilt 1977 · S/N 18265697 N735UQSkylane One LLC · Columbus, OHS/N 18265698 N735URDavis Howard R · Greenwood, MSS/N 18265699 N735UVFly-In LLC · Spanish Fort, ALBuilt 1977 · S/N 18265703 N735UYAlexander Mark R · Waunakee, WIS/N 18265706

Back to Cessna 182Q