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_numberRun 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.
N6901HRieser Steven E II · Baltimore, OHN6905HTang Flyer LLC · Wausau, WIN6911HHarbour Aviation LLC · Weatherford, TXN6915H2gbs LLC · Wilder, IDN6916HFms Air LLC · Leesville, LAN6918HWright Flight Inc · Tucson, AZN6919HTimmester Terry W · Little River, SCN6924HJeea Aviation LLC · Tyler, TXN6926HJust Plane Adventures Inc · Crystal Lake, ILFirst renewal noticeN6936HQuist Donald G · Ridgecrest, CAN6937HTreble Holdings LLC · Dover, OHN6958HJewell Aviation Inc · Kennett, MON6960HZiller Wayne Jr · Fairbury, ILN6964HMor Aviation N6964h LLC · Gaithersburg, MDN696AGWings Over Texas Holdings LLC · Denton, TXN696RCastro Wladimir · Carolina, PRN6970HPerella James C · Cub Run, KYN6973HScheerer Jill · Sag Harbor, NYN6974HWatsonair LLC · Carlsbad, CAN6975HRoot Shane G · Dighton, KSN6979HWhitaker Ian S · Fort Mohave, AZN6981HAll2fly LLC · Atlanta, GAN6983HWaddell Pap LLC · Friendswood, TXN6991HRhinelander Flying Service Inc · Palmetto, FLN6996HWeirich Gayle M · Rockford, MIN69BNSky West Aviation Inc Trustee · Albuquerque, NMN70000Carson Mark L Trustee · Northfield, MNN70004Gbl Aviation LLC · Laurel, MSN70032Alpha Wings Inc · Willoughby, OHN70046Zane Newton F · Rllng Hls Est, CAN70052Hastings Heidi · Wasilla, AKN70095Eastern Kentucky University · Richmond, KYN70196South Shore Flying Club Inc · South Weymouth, MAN70220Perun Av LLC · Cliffside Park, NJN70225Southeast Flight Leasing LLC · Cumming, GAN70228Eagle Sky Patrol Inc · Deadwood, SDN70256Winn Edwin F · Louisville, KYN70323Sky Equity LLC · Woodbury, MNN70340Wings Over Texas Holdings LLC · Denton, TXN70376Sawyer Gregory T · Olga, WAN70378Vertol Systems Company Inc · Destin, FLN70380Mindy Ltd LLC · Muscatine, IAN70386Johnson Ben A · Gainesboro, TNN70392Gateway Flying Club Inc · Blaine, MNN70411Charlie Lima 1 LLC · Jacksonville, FLN70413Lake Elmo Aero LLC · Lake Elmo, MNN70416Mcgee David · West Monroe, LAN70493Starnes Michael A · Murfreesboro, TNN70597Rodriguez Hulises · Chula Vista, CAN707PPattison Bradley D · Gig Harbor, WA
Back to Cessna 172M