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 ('06102FP')
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 ('06102FP')
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.
N295NKKremmin Sky Farm LLC · Milford, IAN295RXTop Crop Aerial Application LLC · Batesville, INN296QGGiesking Mitchel L · Burt, IAN296SGGiesking Mitchel L · Burt, IAN296TTTop Dog Ag LLC · New Vienna, OHN296UTTop Dog Ag LLC · New Vienna, OHN296WRTop Dog Ag LLC · New Vienna, OHN297QNNutrien Ag Solutions Inc · Loveland, CON2986TTopside Ag LLC · Lafayette, INN2993NNutrien Ag Solutions Inc · Loveland, CON299ETTopside Ag LLC · Lafayette, INN299FRRut N Strut Aviation LLC · Shelbyville, KYN299HRRut N Strut Aviation LLC · Shelbyville, KYN299XNDaly Jason DBA · Chillicothe, MON299YABushy Ag Solutions LLC · Caseville, MIN299ZAA&M Ag Drone Services LLC · Maria Stein, OHN3002Bockman Brothers LLC · Milford, IAN3005Bockman Brothers LLC · Milford, IAN301LCLoftis Custom Spraying LLC · Carlisle, ARN302HTSale Reported · Norwalk, IASale reportedN303BEBirds Eye Ag Solutions LLC · Queen Anne, MDN303VDRisley Michael K · Griggsville, ILN303YBBell-Aero Services LLC · Lindsay, NEN304AWWilson Joshua Howard · Garland, NCN304DAVantage Midsouth Inc · Carlisle, ARN304GRCowboy Country Drone Service LLC · Buffalo, WYN304HWDoerr Justin D · Plainview, NEN304XAAerial 360 LLC · Centerville, SDN304YDDoerr Justin D · Plainview, NEN305DCClark Ag LLC · Soda Springs, IDN305XAAerial 360 LLC · Centerville, SDN307WAAce Aerial Applications LLC · Glenwood, INN308LHLoess Hills Aerial Application LLC · Onawa, IAN308SVSunny Valley Aerial LLC · Hayes Center, NEN309DBDeblock Farms Inc · Aledo, ILN309DFOlson Application LLC · Geneseo, ILN309NRRs Rotor Wing Service Llp · Yuma, AZN309RDWorstell James H · Bicknell, INN309RGGraver Ryan A · Malta Bend, MON309SLGoetz Luke · Valparaiso, INN311FAClark Ag LLC · Soda Springs, IDN311NFMake Safe LLC · Kennesaw, GAN312AGAgb Farming LLC · West Unity, OHN313GYYoung Andrew · Erie, ILN322BLAviation Spraying Solutions LLC · Ridgeway, IAN322XESkycrop Drone Solutions LLC · Woodville, TXN323BLAviation Spraying Solutions LLC · Ridgeway, IAN325HXPeabudys Inc · Sterling, ILN326AAAlternative Ag Services & Consultants LLC · Lyndon, ILN326ZEOlsen Erik E · Belton, TX
Back to Xag P100 PRO