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 ('2071402')
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 ('2071402')
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.
N3161NRodriguez Joseph · Sheridan, MIN3163NVasilauskas Steven J · Onalaska, WAN3167NHoff Bros Inc · Idaho Falls, IDN3183NRocque Raymond F · Chattanooga, TNN3185NHarwell Gregory T · Lavonia, GAN3191NDanford Michael S · Oshkosh, WIFirst renewal noticeN3193NAas LLC · Ovid, MIN3199NMcconnell Sarah C · Shepherd, MTN333CMAlbertson James M · Slocomb, ALN33YFrequent Flyer LLC · Manasquan, NJN3524VMayrand Jason P · Nenana, AKN3562VLifland Kenneth D · Lowry Crossing, TXN3678VCowey Kevin M · Pittsburgh, PAFirst renewal noticeN3679VBaird Mark C · Centerville, UTN3684VHollywood Biplane LLC · Atlanta, GAN3690VSather Evan A · Hayward, CAN3748VRowe Lindsey A · Apollo, PAN4001NHarned William C · Lebanon Junction, KYN4007NMurray Madison L · Buena Vista, GAN4013NLingenfelter Stephen D · Davenport, WAN4021NBielecki Gerald M · Vero Beach, FLN4023NZembinski Robert · Brookfield, WIN4029NRidgway Rick J · Carlisle, INN4037NRybarczyk Matt M · Rice Lake, WIN4051NSlayback Eric J · Florence, KYN40648Aanii Media LLC · Dadeville, ALN4071NSmith Jimmy A Jr · Albemarle, NCN4079NKozycz Nathanael J · Penryn, CAN4081NWallace Carey D · Knoxville, TNN4087NKirby Timothy M · Ocala, FLN408NSale Reported · Cades, SCSale reported, pending cancellationN4095NWeaver Al C · Eagle Nest, NMN4111NMcgrath Connor W · Norfolk, VAN4132NFishburne Daniel F · Aiken, SCN4146NPitman Marvin L · Harrah, OKN4154NEnglehart Joseph Michael-John · Walla Walla, WAN4157NLumley William J · Delray Beach, FLN4161NKjv Aviation Inc · Brentwood, CAN4162NDavis Chuck · Santa Paula, CAN4166NRound Robin Aviation Inc · Benton, KSN4176NElsberry Freddie L · Lake Jackson, TXN4181NDesrochers Robert F · Saint Johnsbury, VTFirst renewal noticeN4201NLaverty Jerald · Laverne, OKN4211NTaylor Dale W · Cape Fair, MON4212NGrieff Jorden A · Hollywood, FLFirst renewal noticeN4231NMcintosh Doughlas R · Clarksville, TNN4232NJohnson Stephen G · Salisbury, NCN4236NThornburg Timothy W · Union City, INN4242MPapineau John B · Atchison, KSN4252NEads Arthur H · Jackson, OH
Back to Cessna 120