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 ('2072424')
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 ('2072424')
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.
N8193LDavis Timothy A · Oklahoma City, OKN8196LMoore Nick C · Adamsville, TNN8201LLonghorn Fligh Training LLC · Midlothian, TXN8202LHorizon Flights Corp · Henderson, NVNon-citizen corporation, flight hours not reportedN8204LJohnson Kathy L · Wellsburg, WVN8206LPratt Errol C · Fayetteville, GAN8207LAero Biz Development Group LLC · Washington, DCN8208LMt Avi8or LLC · Sheridan, WYN8209LAbel John R · Haslet, TXN8211LWelch James J · Salisbury, NCN8212LVersaw Charles J · Center, CON8213LTraining Planes LLC · Tampa, FLN8215LUmphrey Reid · Douglasville, GAN8216LWoodworth Mark S · Madison, OHN8217LSteward Kim R · Durand, ILN8218LTufts Kyle J · Hampden, MEN821RMC&C Aero LLC · Billings, MTN8220LFlywyo LLC · Kalispell, MTN8221LAntholz John C · Apple Valley, MNN8222LSimpson Roger E Sr · Moncks Corner, SCN8223LO'Connor Aidan J · East Moriches, NYN8224LCamp Lake Aircraft LLC · Salem Lakes, WIN8225LWebb George Q · Monroe, GAN8229LWuest Steven D · Ripon, WIN8230LBridle Bit Ranch Co · Gillette, WYN8233LKensinger Steve · North Pekin, ILN8236LCiroli Kenneth E · Indiana, PAFirst renewal noticeN8239LSkys Edge Aviation LLC · Midland, TXN8240LCactus To Clouds Aviation LLC · Indio, CAN8246LPatak Eva L · Ennis, TXN8247LKnepp Terry · Montgomery, INN8248LBattleshaw Raymond · Weidman, MIN8250LStieler David C · Marlette, MIN8252LSky And Summit Aviation LLC · Suwanee, GAN8253LKostroski Larry J · Tucson, AZN8254LDennard C Alan · Coolidge, GAN8255LAllen Shaun M · Lake Ann, MIN8262LMclean Corey J · Houston, TXN8264LMorelock Colleen P · Beavercreek, OHN8265LUz Stephanie S · Arlington, VAN8267LInverted Aviation LLC · Atascadero, CAN8269LOneal Gary L · Springdale, ARN8271LLanni David L · Fairbanks, AKN8272LMarfull Eric · Roseville, CAN8276LFly Time Aviation LLC · San Tan Valley, AZN8277LSillers Kim O · Sault Sainte Marie, MIN8281LSliwinski Kellyn E · Anchorage, AKN8283LChapin Devon S · Oxford, CTN8284LMaxwell Barton W Jr · Crawfordsville, INN8286LKyle John M · Wheeling, WV
Back to Cessna 172H