Skip to content

Registered aircraft · 1,805

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

N7365ACable Philip L · Cable, WIBuilt 1956 · S/N 29465 N7367AMatlock Dianne J · East Lansing, MIBuilt 1956 · S/N 29467 N7369AFlying Five Inc · Fort Wayne, INS/N 29469 N7370ASunrise Aero Inc · Ocala, FLBuilt 1956 · S/N 29470 N7371AArth Richard · Newcomerstown, OHBuilt 1956 · S/N 29471 N7373ABaker Thaddeus J · Elk, WAS/N 29473 N7377ARfk Aerospace LLC · Clayton, NCS/N 29477 N7379ANguyen Tuong · Henderson, NVBuilt 1956 · S/N 29479 N7385AColli Guido F · Miami, FLBuilt 1957 · S/N 29485 N7386ADrum Keith Brian · Clover, SCBuilt 1956 · S/N 29486 N7387AColberg Hans S · Palmer, AKBuilt 1956 · S/N 29487 N7391AMitchell Vernon · Waxahachie, TXBuilt 1957 · S/N 29491 N7394AFreer Lawrence C III · Puyallup, WABuilt 1956 · S/N 29494 N7397AWillems Scott F · Cottonwood, CABuilt 1956 · S/N 29497 N7400AHarrop Brian C · Mesa, AZBuilt 1957 · S/N 29500 N7407AKremmling Flying Inc · Kremmling, COS/N 29507 N7408AJohnston Lynwood A · Anchorage, AKS/N 29508 N7411ACoverdill Robert E · Savoy, ILBuilt 1956 · S/N 29511 N7414AMutter Wilson T · Chelan, WABuilt 1956 · S/N 29514 N7415ASmith Kevin L · Peachtree City, GABuilt 1956 · S/N 29515 N7416AAce Flying Co LLC · Wichita, KSBuilt 1956 · S/N 29516 N7417AKoons Bill R · Centerville, MOBuilt 1956 · S/N 29517 N7419ACliff Lloyd B · Hemet, CABuilt 1957 · S/N 29519 N7421AHarris David C · Ventura, CABuilt 1956 · S/N 29521 N7422ABeardsley Albert R · Byrdstown, TNBuilt 1957 · S/N 29522 N7426AAdkins George E · Brooklyn, IABuilt 1956 · S/N 29526 N7427AFlaps Forty LLC · East Wenatchee, WABuilt 1956 · S/N 29527 N7430ANeilsen Lorenzo I · Wilmington, NCBuilt 1956 · S/N 29530 N7431AAero Care Inc · Orange, MAS/N 29531 N7433ASmith Larry D · Friendswood, TXBuilt 1956 · S/N 29533 N7438AKellogg Charlie H · Oxnard, CABuilt 1956 · S/N 29538 N7439AAlsterlind Stephen W · San Rafael, CABuilt 1956 · S/N 29539 N7440AN7440a LLC · Howell, MIBuilt 1956 · S/N 29540 N7441AMadison Nicholas R · Fayette, ALBuilt 1959 · S/N 29541 N7452AHill Nathaniel J · Goldendale, WABuilt 1956 · S/N 29552 N7453ASwope Aviation Solutions LLC · Independence, MOBuilt 1956 · S/N 29553 N7454AMoore Robert L · Anderson, CABuilt 1956 · S/N 29554 N7455AApplied Products LLC · Grove, OKBuilt 1956 · S/N 29555 N7457AHottenstein John C · Rifle, COS/N 29557 N7458ARegistration Pending · Waynesville, OHRegistration pendingBuilt 1956 · S/N 29558 N7461AJohnson Jeffrey M · Versailles, KYBuilt 1956 · S/N 29561 N7462ABenallo Joseph D · Homer, AKBuilt 1956 · S/N 29562 N7463AVandenbelt Kenneth J · Leslie, MIS/N 29563 N7464ANotch Paul L · Kennewick, WABuilt 1956 · S/N 29564 N7465AGoss Brian L · Fairbanks, AKS/N 29565 N7467AAshurst Griffith P · Fresno, CAS/N 29567 N7470AAnnas Michael W · Franklin, GABuilt 1956 · S/N 29570 N7472APitman Marvin L · Harrah, OKBuilt 1956 · S/N 29572 N7474ALazar Peter · Morriston, FLS/N 29574 N7475AHayden Daniel · North Pole, AKBuilt 1956 · S/N 29575

Back to Cessna 172