Skip to content

Registered aircraft · 1,636

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

N24816Graves James A Trustee · Norman, OKBuilt 1977 · S/N 15280396 N24831Bishop Darin R · Livermore, CABuilt 1977 · S/N 15280403 N24856Mccreary Aviation LLC · Green Valley, AZBuilt 1977 · S/N 15280414 N24857Pea-Wayman Flight LLC · Daytona Beach, FLBuilt 1977 · S/N 15280415 N24874Sunrise Aviation Inc · Ormond Beach, FLBuilt 1978 · S/N 15280427 N24884Bravo Victor LLC · Afton, WYFirst renewal noticeBuilt 1977 · S/N 15280431 N24886Warrior II Ltd · Des Plaines, ILBuilt 1977 · S/N 15280432 N24887Sunrise Aviation Inc · Ormond Beach, FLS/N 15280433 N24895Lokker Dirk E · Oakdale, CABuilt 1977 · S/N 15280438 N24908Hnatio Matthew J · South Deerfield, MABuilt 1977 · S/N 15280445 N24920Springett Justin · Boulder, COS/N 15280450 N24932Silver Express Co DBA · Miami, FLBuilt 1977 · S/N 15280456 N24933Leslie Ethel M · Paonia, COBuilt 1977 · S/N 15280457 N2493845u Leasing LLC · Beaver Creek, OHBuilt 1977 · S/N 15280459 N24947Aty Aviation Inc · Watertown, SDS/N 15280464 N24950Erbisch Robert · Fruita, COBuilt 1977 · S/N 15280467 N24981R&R Aero Services LLC · Eden Prairie, MNBuilt 1977 · S/N 15280490 N24986Charlston Michael M · Haleiwa, HIBuilt 1977 · S/N 15280495 N24995Stiles Robert K · Lynden, WABuilt 1977 · S/N 15280502 N24998Airplanes And Helicopters Of Oregon LLC · Sisters, ORBuilt 1977 · S/N 15280503 N25028East Hill Flying Club Inc · Ithaca, NYBuilt 1977 · S/N 15280505 N25047Sunrise Aviation Inc · Ormond Beach, FLBuilt 1977 · S/N 15280514 N25053Southwinds Export Inc · Kissimmee, FLNon-citizen corporation, flight hours not reportedS/N 15280517 N25057Nino Jose · Kenilworth, NJBuilt 1977 · S/N 15280520 N25216Mcfarlane Claude L III · Fitchburg, WIBuilt 1977 · S/N 15280534 N25221Hillsboro Aero Academy LLC · Hillsboro, ORBuilt 1977 · S/N 15280538 N25225Howard Jeff S · Anderson, SCBuilt 1977 · S/N 15280541 N25228Laguna Verde Leasing Inc · Wilmington, DES/N 15280543 N25233Hillsboro Aero Academy LLC · Hillsboro, ORBuilt 1977 · S/N 15280545 N25255Flm Aviation LLC · Vernal, UTBuilt 1977 · S/N 15280556 N25265My Toys Inc · Spartanburg, SCS/N 15280561 N25269Yankaskas Kurt D · Ijamsville, MDBuilt 1977 · S/N 15280563 N25271Byrnes Daniel P · Anchorage, AKS/N 15280564 N25284Riverside Flight Center Inc · Tulsa, OKBuilt 1977 · S/N 15280572 N25286Recreational Enterprises LLC · Sanford, FLS/N 15280573 N252MTAero Quest LLC · Olive Branch, MSBuilt 1977 · S/N 15280407 N252WCMosier Paul L · Ventura, CABuilt 1979 · S/N 15284145 N25301Southern Arkansas University Technical Branch · Camden, ARBuilt 1977 · S/N 15280581 N25302Steiner Jason A · Sabetha, KSBuilt 1977 · S/N 15280582 N25325Sunrise Aviation Inc · Ormond Beach, FLBuilt 1977 · S/N 15280596 N25332Ewing John L Jr · Yuma, AZBuilt 1977 · S/N 15280600 N25351Russell Robert Q · Genoa City, WIBuilt 1977 · S/N 15280609 N25357Jameson George T · Auburn, MABuilt 1977 · S/N 15280612 N25359Kelly John M · Gastonia, NCBuilt 1977 · S/N 15280614 N25362Sunrise Aviation Inc · Ormond Beach, FLBuilt 1977 · S/N 15280616 N25393Oliver Blake H · Talbotton, GAS/N 15280631 N25399Hudson Donald L · Camarillo, CABuilt 1977 · S/N 15280633 N25408Thompson David J · Pemberton, NJBuilt 1977 · S/N 15280637 N25413Dreamair Aviation Inc · Boca Raton, FLBuilt 1977 · S/N 15280641 N25416Mikes Aircraft Shop Inc · Corpus Christi, TXBuilt 1977 · S/N 15280643

Back to Cessna 152