Skip to content

Registered aircraft · 3,573

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

N100CGGreene Carol W · Mahwah, NJBuilt 1972 · S/N 17261191 N100MSky Odyssey Aviation LLC · Gulf Breeze, FLBuilt 1975 · S/N 17265590 N100RKEllingson Leslie B · Harwood, NDBuilt 1974 · S/N 17263551 N101KSWright Kenneth D · Benton, ARBuilt 1974 · S/N 17263095 N101LJGrenier Garret P · Anchorage, AKBuilt 1976 · S/N 17267273 N101RKBlake James R · Marion, LABuilt 1972 · S/N 17261166 N101USUsaeroflight LLC · Greenville, SCBuilt 1972 · S/N 17260922 N102PRRico Aviation Services Inc · Miami, FLBuilt 1976 · S/N 17266462 N10446Schell Brothers II LLC · Rehoboth Beach, DEBuilt 1973 · S/N 172-62515 N104NPDv Aviation Inc · Brainerd, MNBuilt 1975 · S/N 17265021 N104PDBaumann James R · Muskogee, OKBuilt 1973 · S/N 17261428 N105PDN105pd LLC · Ulysses, KSBuilt 1973 · S/N 17261469 N106GCJones Michael D · Warner Robins, GABuilt 1975 · S/N 17264663 N1074TIowa Lakes Community College · Estherville, IABuilt 1973 · S/N 17262233 N107ESWalpole John W · Iola, TXBuilt 1976 · S/N 17266853 N107RARl Aviation LLC · Miami, FLBuilt 1974 · S/N 17263334 N107RFStevens Matthew S · Penn Yan, NYBuilt 1972 · S/N 17260862 N1086UHancock County Port & Harbor Commission · Kiln, MSBuilt 1976 · S/N 17266835 N1088UWestern Wyoming Aviation Services LLC · Pinedale, WYBuilt 1976 · S/N 17266837 N1089UJkg LLC · Murfreesboro, TNBuilt 1976 · S/N 17266838 N108JMHarris Kenneth L · Greeley, COBuilt 1976 · S/N 17266768 N1094UBrajnikoff Edward C · San Francisco, CABuilt 1976 · S/N 17266843 N1095UMalahmeh Adel J · New Iberia, LAS/N 17266844 N1096UBraten Randall O · Cody, WYBuilt 1976 · S/N 17266845 N1098UKane Patrick · Chicago, ILBuilt 1976 · S/N 17266847 N1109USky Quest Inc · Wilmington, DEBuilt 1976 · S/N 17266849 N110AUHernandez-Santiago Ruben A · Ponce, PRBuilt 1975 · S/N 17265538 N110BXCk Leasing Services LLC · Wilmington, DEBuilt 1974 · S/N 17263746 N11115Crist Steve · Reno, NVS/N 17262410 N1115UAvian Leasing LLC · Bremerton, WABuilt 1976 · S/N 17266851 N1117UBhp Aviation · Santa Clara, CABuilt 1976 · S/N 17266852 N111SA111sa LLC · Greeley, COBuilt 1972 · S/N 17260937 N1128UElw Inc · Bonners Ferry, IDBuilt 1976 · S/N 17266857 N1129USchroeder Herbert D · Plano, TXBuilt 1976 · S/N 17266858 N112APAerospace Trust Management LLC Trustee · Wilmington, DES/N 17262038 N1130UTc Aviation LLC · Denham Springs, LAS/N 17266859 N1133UMustachio Donald · East Stroudsburg, PABuilt 1976 · S/N 17266862 N1134UWells William L · Santa Cruz, CABuilt 1976 · S/N 17266863 N1137UFoscap Air LLC · Las Vegas, NVBuilt 1976 · S/N 17266866 N1139UFettig Peter J · Bismarck, NDBuilt 1976 · S/N 17266868 N113BAPreston Richard R Trustee · Albuquerque, NMBuilt 1975 · S/N 17266046 N113DRCalifornia In Nice Inc · San Jose, CABuilt 1975 · S/N 17265961 N113FSHallahan Robert J · Central Square, NYBuilt 1974 · S/N 17262996 N1141UFlight School Inc · Spring, TXBuilt 1976 · S/N 17266870 N1165UWings Over Texas Holdings LLC · Denton, TXBuilt 1976 · S/N 17266872 N116CRConti Christine M · Plantation, FLBuilt 1976 · S/N 17266985 N1176UPlane Leasing LLC · Wilmington, DEBuilt 1976 · S/N 17266877 N1179UBadgerland Aero Club Inc · Fitchburg, WIBuilt 1976 · S/N 17266880 N1180UAom Aircraft LLC · Wilmington, DES/N 17266881 N1181U404 Ltd · Pulaski, WIBuilt 1976 · S/N 17266882

Back to Cessna 172M