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.
N3819ASkydronesusa LLC · Gowrie, IAN382QAAirstrike Ag LLC · Barnum, IAN382UAAirstrike Ag LLC · Barnum, IAN385RFVwb Custom LLC · Morrison, ILN385RNRainbolt Enterprises LLC · Okemah, OKN386SDAgri-Dynamics LLC · Woonsocket, SDN3879ASale Reported · Latimer, IASale reportedN387DBEd Braun Inc · Cedar Rapids, NEN387HPPeterson Curtis L · Wendell, IDN387KDKassel Drones LLC · Menno, SDN387SDAgri-Dynamics LLC · Woonsocket, SDN387VMMinnkota Aerial LLC · Hancock, MNN3880AAmiotte Aviation LLC · Dupree, SDN3886SMcdonnell Farms · Quinn, SDN3887ASkydronesusa LLC · Gowrie, IAN3888EGiesking Mitchel · Burt, IAN3889AFolkmann Crop Services LLC · Marengo, IAN388AQFast Pass Ag LLC · Weston, NEN388FAFolkmann Crop Services LLC · Marengo, IAN388GXSale Reported · Monroe, IASale reportedN388KAAirstrike Ag LLC · Barnum, IAN388MARegistration Pending · Elgin, MNRegistration pendingN388NCInnovative Drone Solutions LLC · Manson, IAN388PRHillview Angus Inc · Pulaski, IAN388QZAirstrike Ag LLC · Barnum, IAN388SSAirstrike Ag LLC · Barnum, IAN388UAAirstrike Ag LLC · Barnum, IAN388VAAirstrike Ag LLC · Barnum, IAN388XAAirstrike Ag LLC · Barnum, IAN388ZYAmiotte Aviation LLC · Dupree, SDN389ESAirstrike Ag LLC · Barnum, IAN389FAAirstrike Ag LLC · Barnum, IAN389HZAirstrike Ag LLC · Barnum, IAN389QAAirstrike Ag LLC · Barnum, IAN389UAAirstrike Ag LLC · Barnum, IAN38HCRk Air & Land Investments LLC · Wichita Falls, TXN390BKAg Drone Service LLC · Glendo, WYN391NRooted Agronomy LLC · Manning, IAN392NCooperative Farmers Elevator · George, IAN394NCooperative Farmers Elevator · George, IAN394SASouthern Ag Spray Drones LLC · Robertsdale, ALN395KAKrohn Acres LLC · Owendale, MIN395NCooperative Farmers Elevator · George, IAN398LUNo Creek Custom Drone Applications LLC · Trenton, MON402AKKleinschmit Adam · Wausa, NEN405HSHigh Speed Ag LLC · Atwood, KSN405RDRanch Drone Solutions LLC · Hydro, OKN4066Erickson Bruce L · Montevideo, MNN406BDPrecision Spray Drones LLC · Hale, MON407HEHomeland Surveillance & Electronics LLC · Casselberry, FL
Back to Xag P100 PRO