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.
N409DBDeblock Farms Inc · Aledo, ILN411CTCrop Tech Hts LLC · Lubbock, TXN412SDSandhills Drone Ops LLC · Angora, NEN42NASkyline Precision Ag LLC · Stanley, NDN430QCCroy Aerial Applications LLC · Laotto, INN431HBJm Ag Service LLC · Durand, MIN434HHHorrall Jacob R · Vincennes, INN434YJOverman Josh · Fort Recovery, OHN438DMSkydronesusa LLC · Gowrie, IAN440AGTerraplex Ag LLC · Odebolt, IAN442LUMake Safe LLC · Kennesaw, GAN4450MMidwest Crop Solutions LLC · Carlisle, IAN4453MMidwest Crop Solutions LLC · Carlisle, IAN446GPAg Pro Drone Service LLC · Corunna, MIN446HAAg Pro Drone Service LLC · Corunna, MIN446LMMiller Nicholas · Weston, MON4470TTuel Justin · Coon Rapids, IAN447SLLegacy Ag Solutions LLC · Terre Haute, INN447TLLegacy Ag Solutions LLC · Terre Haute, INN448VSPrecision Drone Services LLC · Obion, TNN4494TTwo Drones And A Guy LLC · Jackson, MIN451WXSinn Precision Aero LLC · Sherburn, MNN452CSSf Farms LLC · Bicknell, INN452QAAg Drone Service LLC · Glendo, WYN452RXXceed Ag LLC · Union City, TNN452SXXceed Ag LLC · Union City, TNN453ABScanga Brothers LLC · Pierce, CON455VAGreiner Nick · Parma, MIN4576MMarlatt Fertilizer Aerial Services LLC · Rushville, INN457KNNc State University · Raleigh, NCN4580TTng Farmer LLC · Lafayette, INN460AGTerraplex Ag LLC · Odebolt, IAN460RCRc Agriculture LLC · Burley, IDN460TXFlying L Aviation LLC · Emmetsburg, IAN461TXFlying L Aviation LLC · Emmetsburg, IAN4635FFirelands Farmstead Operations LLC · Greenwich, OHN465MTAc Farms Inc · Rudyard, MTN465QFFeucht Philip J · Larchwood, IAN466PUUav Precision Agriculture LLC · Spencer, INN466RLOld Barn Drone Works LLC · Poplar Grove, ILN4676NNew Heydt'S Agridrone Service LLC · Silverstreet, SCN467GEEternity Agri Services LLC · Dunlap, IAN467HEEternity Agri Services LLC · Dunlap, IAN469WDDevore Custom Ag LLC · Weldon, IAN46GWGreenwing LLC · Whitehall, MTN4709JL&J Ag Services LLC · Colchester, ILN470GTIndiana Ground Tech LLC · Boggstown, INN471CTCrop Tech Hts LLC · Lubbock, TXN472RSSoutheast Drone Service LLC · Saltillo, MSN473VHHenkle Honker Farms LLC · Grafton, IA
Back to Xag P100 PRO