Skip to content

Registered aircraft · 781

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

N2482LTrubowicz Maciej Piotr · Cornelius, NCBuilt 1966 · S/N 17255682 N2484LLuv2fly LLC · San Antonio, TXS/N 17255684 N2489LCalifornia Aviation Services Inc · Riverside, CABuilt 1966 · S/N 17255689 N248ZLightsey Aviation LLC · Jacksonville, FLBuilt 1967 · S/N 17256247 N2490LWimberly Thomas F III · Bend, ORBuilt 1966 · S/N 17255690 N2491LMcgivern James · San Pedro, CABuilt 1966 · S/N 17255691 N2496LSequeira Michael J · Troy, MOBuilt 1966 · S/N 17255696 N2498LJohn Kit M · Shoshone, IDBuilt 1966 · S/N 17255698 N2500LRice Nancy Kay · Leesburg, TXBuilt 1966 · S/N 17255700 N2504LRogers Carol J · Hampshire, ILBuilt 1966 · S/N 17255704 N2505LCannon Jason P · La Verne, CABuilt 1966 · S/N 17255705 N2509LSchufeldt Lawrence H · North Platte, NEBuilt 1966 · S/N 17255709 N2511LDmcflight LLC · Boynton Beach, FLS/N 17255711 N2513LDahlberg James C · Ogilvie, MNBuilt 1966 · S/N 17255713 N2514LRegistration Pending · Macclenny, FLRegistration pendingS/N 17255714 N2515LClear Air Aviation LLC · Talkeetna, AKBuilt 1966 · S/N 17255715 N2516LFlores E Alex · Missouri City, TXBuilt 1966 · S/N 17255716 N2517LCarroll Mark E · Nicholasville, KYBuilt 1966 · S/N 17255717 N2519L2 G Group LLC · Honolulu, HIBuilt 1966 · S/N 17255719 N2520LPeck M Hayden II · Bells, TXBuilt 1966 · S/N 17255720 N2521LExpert Construction Services LLC · Mclean, VAFirst renewal noticeBuilt 1966 · S/N 17255721 N2524LGraham Jacob W · Rose Hill, KSBuilt 1966 · S/N 17255724 N2527LWooten Craig J · Campobello, SCS/N 17255727 N2528LWings Of Faith · Stevensville, MTBuilt 1966 · S/N 17255728 N2530LSholes Lance M · Oregon City, ORBuilt 1966 · S/N 17255730 N2531LAiken Justin M · Arden, NCS/N 17255731 N2536LLink Kim D · Golden Valley, NDBuilt 1966 · S/N 17255736 N2537LOneill Timothy J · Clyo, GABuilt 1966 · S/N 17255737 N2547LDavis Tyler · Laurinburg, NCBuilt 1966 · S/N 17255747 N2549LSiemon Mark R · Belle Plaine, MNBuilt 1966 · S/N 17255749 N2550LWooten Craig J · Campobello, SCS/N 17255750 N2552LFirst Flight Corp · San Diego, CABuilt 1967 · S/N 17255752 N2554LAirheads Inc · Charles Town, WVBuilt 1967 · S/N 17255754 N2555LGates Kimberly B · Kintnersville, PABuilt 1967 · S/N 17255755 N2557LSparks Ryan J · Peculiar, MOBuilt 1967 · S/N 17255757 N2558LHoecher Robert · Anchorage, AKS/N 17255758 N2559LFlying Circus LLC · Bridgeport, WVBuilt 1967 · S/N 17255759 N2562LWilkey Paul W · Sullivan, INBuilt 1967 · S/N 17255762 N2570LHerman John K Jr · Flagler, COBuilt 1967 · S/N 17255770 N2571LClements Jim L · Cushing, OKBuilt 1967 · S/N 17255771 N2576LRiggin Flight Service Inc · Madison, SDS/N 17255776 N2577LKim L Jensen · Enoch, UTBuilt 1967 · S/N 17255777 N2582LRichardson Michael Todd · Wilkesboro, NCS/N 17255782 N2583LMontgomery Robert A · Hampstead, NCBuilt 1967 · S/N 17255783 N2585LAerospace Quality LLC · Piggott, ARS/N 17255785 N2586LRuiz Edinson · Bakersfield, CABuilt 1967 · S/N 17255786 N2591LHettenbach Paul A · Carrollton, TXBuilt 1967 · S/N 17255791 N2593LDaly Moses M · Underhill, VTBuilt 1967 · S/N 17255793 N2594LSheldon Paul T · Saint James, MNBuilt 1967 · S/N 17255794 N2595LPiper Capital Growth Fund LLC · Scottsdale, AZBuilt 1967 · S/N 17255795

Back to Cessna 172H