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.
N3787RLummus Brett D · Forney, TXN3788FJohnson David M · Macon, GAN3788RMayer Robert J · San Diego, CAN3789FJohnson Rachel H · Terrytown, LAN3789RRegistration Pending · Eagle River, AKRegistration pending, canceledN3790RSjostedt Brad D · Cordova, AKN3792FSeals Floyd · San Marcos, CAN3794FN3794f LLC · Key West, FLN3794RHollis John A · Payette, IDN3795FSokolowski Maurycy J · Largo, FLN3795RBracilano Robert A · Virginia Beach, VAN3796RSchapiro Alan R · Alta Loma, CAN3797FMartin James G · Lagrange, GAN3797RSullivan John P · Peyton, CON3799F99foxtrot LLC · Middletown, DEN3804RVorhees Tyler R · Rockford, ILN3806RMartin Gary J · Glasgow, MTN3809RImhof Donald R · Central City, NEN3818RRuddle Aviation LLC · Lawrenceburg, TNN3819RMeznarsic Victor F · Alton, ILN3823RElectra-Vision Advertising Corp · Claremont, CAN3825RHoogstra Jay D · Sheboygan Falls, WIN3827RSeaplanes R Fun Inc · Wilmington, DEN3829RGibbons Warren · Toledo, OHN3830RPace Michael C · Atlanta, GAN3832RDemopoulos Chris · Dyer, INN3836RWard David E · Quilcene, WAN3838RAviation Rentals LLC · Oakman, GAN3843RHarbor View Air LLC · Kalispell, MTN3845RDelaney Patrick James · Marion, TXN3846RSampson Corey · Newnan, GAN3848RGunter Jeffrey W · Demorest, GAN3849RSims Charles H · Soldotna, AKN3850RKelley Patrick W · Charlo, MTN3852RChristman Mike G · Wasilla, AKN3855RAircraft Investment Group LLC · Cookeville, TNN3856RSmith Joseph M · Juneau, AKN3857RLorring Eric Henry · Kodiak, AKN3859RLeja Dennis A · Watertown, WIN385CHL H Aviation LLC · Clanton, ALN3861RShawn James Robert · Pattison, TXN3863ROkeefe Dennis G · Cincinnati, OHN3864RR Thimesch Construction LLC · Spivey, KSN3867RHowser Timmy L · Batavia, OHN3869RErl Don L · Medford, WIN3872RS&Sa Aviation LLC · Colby, KSN3873RFoster William G Jr · Sunnyvale, CAN3874RMartig Glenn A · Lino Lakes, MNN3876RTriple Farms DBA · Sikeston, MON3878RSs Farms Operating LLC · Hydro, OK
Back to Cessna 172H