Skip to content

Registered aircraft · 718

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

N5679RSandy River Flying Club · Wilton, MES/N 17253319 N5680RBraun Joshua H · Springfield, MOBuilt 1965 · S/N 17253320 N5683RLewis George H · Brookline, NHBuilt 1965 · S/N 17253324 N5684RGorton Horace B · Overland Park, KSBuilt 1965 · S/N 17253326 N5686RLogan Kevin · Amarillo, TXS/N 17253329 N5687REsch Randall L · Stanton, MIBuilt 1965 · S/N 17253330 N5690RMcveigh Ian Thomas · Mansfield, TXBuilt 1965 · S/N 17253334 N5691RBase 2 Final Fleet LLC · Mckinney, TXBuilt 1965 · S/N 17253336 N5696RMagnolia Flight Aviation LLC · Pontotoc, MSBuilt 1965 · S/N 17253343 N5699RNoriega Vanessa · Miami, FLS/N 17253349 N56ACLatham Randall W · Georgetown, OHBuilt 1964 · S/N 17252416 N5700RSpindler Dale A · Auburn, WABuilt 1965 · S/N 17253350 N5705RRucker David G · New Waverly, TXBuilt 1965 · S/N 17253359 N5707RIoele Brian · West Henrietta, NYBuilt 1965 · S/N 17253362 N5709RNick Monsen Trucking Inc · Buffalo Center, IABuilt 1965 · S/N 17253366 N5710RMarshall Fred R · Tulsa, OKBuilt 1965 · S/N 17253367 N5712RGlobal Learning Solutions Inc · Montrose, COBuilt 1965 · S/N 17253370 N5713RAirspeed Marketing LLC · Phoenix, AZBuilt 1965 · S/N 17253372 N5716RUdenburg Scott M · Cotter, ARBuilt 1965 · S/N 17253378 N5719RProfessional Aviation Aircraft Services Ltd · New Philadelphia, OHBuilt 1965 · S/N 17253383 N5722RCalhoun Barry R · Richardson, TXBuilt 1965 · S/N 17253387 N5723RCoffey Bryan K · Anchorage, AKBuilt 1965 · S/N 17253389 N615AHRusty Crate LLC · Wynne, ARS/N 17252337 N634WGWings Of Grace Ministries Inc · Melbourne, FLFirst renewal noticeBuilt 1965 · S/N 17252781 N635MSpl Invest LLC · Chandler, AZBuilt 1964 · S/N 17252253 N65172Kfam Enterprises LLC · Dover, DES/N 17252998 N717VVSouthern Kentucky Flying Club LLC · Bowling Green, KYBuilt 1964 · S/N 17252246 N723LCLudwig Robert P · Pflugerville, TXBuilt 1965 · S/N 17253332 N725LCReeves Jerry H · Whitesburg, GABuilt 1964 · S/N 17251919 N7770ASampson Zachary J · New Braunfels, TXS/N 17252309 N7774ASaydun LLC · Richardson, TXBuilt 1964 · S/N 17252168 N7825UVan Dyke Randall R · Spencer, IABuilt 1964 · S/N 17251825 N7826UDenton Aeroworx LLC · Tucson, AZBuilt 1964 · S/N 17251826 N7827UCook Loretta · Bel Air, MDBuilt 1964 · S/N 17251827 N7828UDroz Chris G · Jamul, CAS/N 17251828 N7830UObrien Cornelius R · Sellersville, PABuilt 1964 · S/N 17251830 N7831UHerrin Thomas · Patterson, GABuilt 1964 · S/N 17251831 N7832UFly 32u LLC · Monroe, NCBuilt 1964 · S/N 17251832 N7833ULfs Inc · Gillette, WYBuilt 1964 · S/N 17251833 N7834USirens Call LLC · Nashville, TNBuilt 1964 · S/N 17251834 N7835UEyrie Aviation LLC · Suwanee, GAFirst renewal noticeBuilt 1964 · S/N 17251835 N7837UCommander Aviation LLC · Monroe, MIBuilt 1964 · S/N 17251837 N7840UKay Bennie L · Brigham City, UTBuilt 1964 · S/N 17251840 N7841ULiles Edward N · Siler City, NCBuilt 1964 · S/N 17251841 N7842USelig Benjamin L · Arlington, VAS/N 17251842 N7843UHarkrader Aviation LLC · Louisa, VABuilt 1964 · S/N 17251843 N7844UMyers Russell E · Happy Jack, AZBuilt 1964 · S/N 17251844 N7846UCrisco Millwright Services LLC · Lewes, DEBuilt 1964 · S/N 17251846 N7847UFinnegan James M · West Valley City, UTBuilt 1964 · S/N 17251847 N7850UJohnson Lawrence F · Sacramento, CABuilt 1964 · S/N 17251850

Back to Cessna 172F