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.
N5218QRoberson J R · Mabank, TXN5219RCoston Mace C · Maryville, MON521GTNeptune Skies LLC · Little Elm, TXN5220RChaz L Enterprises LLC · Ringwood, NJN5221RDunaway Jeffrey W · Bremerton, WAN5223RN5223r LLC · Opa Locka, FLN5228RMtc Leasing LLC · Sandersville, GAN5229ROcala Aviation Services Inc · Ocala, FLN522DCBateson Mark A · Roseville, CAN5231HTilley Daniel D · Grove City, OHN5231RPml Aero Club LLC · Groveland, CAN5234RLanier Dale J · Willis, TXN5235RRegistered aircraftN5237HSmith Richard D · Powell Butte, ORN5240RRico Aviation Services Inc · Miami, FLN5242RProctor Daniel L · Elkton, VAN5243RDraco Flight School Inc · Chino, CAN5244RClauson Ed P · Charlestown, RIN5247RHarbour Aviation LLC · Weatherford, TXN5249RHigh Exposure Inc · Wilmington, DEFirst renewal noticeN5251HLuyster Roy A · Rochelle Park, NJN5251RLong Island Aviators LLC · Seaford, NYN5253RAmerican Patrols Inc · Midland, TXN5256HHenley Robert J · Jeffersonville, INN5257HWellman David H · Eugene, ORN5257RTheodossiou Chris · Mandeville, LAN5258RZwiesler Thomas F · Ellington, CTN5259HTrifunovic Stefan · Grosse Pointe Park, MIN5259RCarnathan Robert J · Newark, CAN5260RSouthern Aero LLC · Homestead, FLN5262HBun Air Corp · Bedford, PAN5265RMoss Hill Airport Inc · Kinston, NCN5268HGrander Aviation LLC · Panama City Beach, FLN5268RJohnson Steven D · Oklahoma City, OKN5270HR & D Aircraft Inc · Jamestown, NCN5271RAyala-Moore Kristopher · Tucson, AZN5272RRichmond Pilots Corp · Linden, NJN5273RClear Prop Aviation LLC · Sterling, VAN5274HLincoln Skyways Inc · Lincoln, CAN5278RHussain Mahmoud Taimour Said · Miami, FLN5283RFellow Ship Aviation LLC · Monticello, GAN5284QWings Over Texas Holdings LLC · Denton, TXN5284RDahlke Philip H · Smyrna, GAN5285HChild Cris · Mapleton, UTN5286HNieves Irvyn T · Vega Baja, PRN528STStanlake Lowell P · Grand Forks, NDN5292REss Adventures LLC · Damascus, ARN5294RRemus Stephen J · Warren, MIN5296RB&R Aircraft LLC · Wadsworth, OHN5297RWaltman Jack J · Forbes, ND
Back to Cessna 172M