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 ('2073709', '2073710')
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 ('2073709', '2073710')
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.
N2572VJarvis Michael Lynn · Orem, UTN2573VOldfield Raymond M Jr · Waupaca, WIN2575VStone Tommy R · Jacksonville Beach, FLN2581VMink Stephen Earl · Walnut Creek, CAN258KCBredesen Benjamin C · Nashville, TNN2591VLivewire Holdings LLC · Salinas, CAN25LGJolymug LLC · Saratoga, CAN25RTOverton Clayton J III · Sioux Falls, SDN2614VMorris Daniel J · Bossier City, LAN2629VEyw Flying LLC · Key West, FLN2630VAgue Curtis M · Kailua, HIN2638VWells Larry C · Flowood, MSN2639VBowen Keith S · Lyle, WAN2640VBube Douglas G · Clarkston, WAN2643VGorman Sean P · Superior, CON2648VWhite Jeffrey W · Macon, GAN2652VTrapp Terry Lee Trustee · The Dalles, ORN2654VVankirwin Inc · Kinnelon, NJRegistration expired, pending cancellationN2662VPeck Kim O · Bolton, MAN2664VKeaveny Kelly J · Annandale, MNN2672VWhite Robe · Castro Valley, CAN2673VJackson R N · Southlake, TXN2674VMoroil Corp · Davidson, NCN2683VPeters Robert M · Fremont, INN2688VHampel Michael J · Camas, WAN2691VHanlon James Bradley Trustee · Fallbrook, CAN2692VKlr Aircraft Sales LLC · Wilmington, DEN2703VInman David M · Vancouver, WAN2706VBeuschel Timothy W · Mount Pleasant, WIN2726VTurpin Michael · Rcho Sta Marg, CAN2727VFitzgerald Kevin C · College Station, TXN2733VOlson Kirk · Dickinson, NDN2740VTheo Enterprises LLC · New Castle, DEN274DAArnold Randall L · Corpus Christi, TXN2752VAnninos Peter J · Seal Beach, CAN2753VSirius Real Estate LLC · Murphys, CAN2756VWilson Elmer W · Enterprise, ALN2757VRasnake Larry J · Charlotte, NCN2758VRichey Reginald Wade · Lincoln, NMN2759VRedwing Aviation LLC · San Antonio, TXN2760VFinish Line - N2760v LLC · Edmond, OKN2768VRegistration Pending · Woodland Hills, CARegistration pendingN2773VBeale Air Force Base Aero Club · Beale Afb, CAN278SAInternational Air Services Inc Trustee · Carson City, NVN27JSSmith Cattle Company LLC · Steamboat Rock, IAN299RQRds Aviation LLC · Powder Springs, GAN29LKGibbons David · Holmen, WIN300PAmerican Aviator LLC · Arlington, TXN309LLSweepyacres LLC · Greenbrier, TNN312AMDueck Arthur Peter · Lakewood, OH
Back to Cessna 177RG