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.
N475CEDrone Dynamics LLC · Tuscola, ILN47994Airgrow Drone Services LLC · Wingate, INN4799MMinnkota Aerial LLC · Hancock, MNN479MDRegistered aircraftN-number assigned (non-type certificated), not yet registeredN480DMSobotka Farms LLC · Laurens, IAN485DMSykes Southern Acres · Crawford, MSN485MTAc Farms Inc · Rudyard, MTN485TTTerraplex Ag LLC · Odebolt, IAN4861KVandenhull Kyle · Alcester, SDN489SSFahrmeier Samuel · Wellington, MON491MSSky Guy Drone Application LLC · Bluffton, INN494HCHuron County Drone Services LLC · Kinde, MIN494YUUnion Argo Services LLC · Mifflinburg, PAN4955Hanson Samuel C · Webb, IAN496CBNorth Missouri Aerial Application LLC · Laredo, MON496DNMountain View Drone Applications LLC · Mountain Lake, MNN4973AAppanoose Drones LLC · Moulton, IAN497ZRRamseyer Kevin · Poneto, INN500EPFlokstra Andrew T · Marshall, MIN50195Pocasaw Aerial Solutions LLC · Aberdeen, SDN501XATitan Ag LLC · Humboldt, TNN5046SSeward Crop Solutions LLC · Rockville, INN504EETwo Drones And A Guy LLC · Jackson, MIN505BCBunker Consulting LLC · Little Rock, ARN516JSSeward Crop Solutions LLC · Rockville, INN53244-L Family Farms LLC · Shelbyville, MIN533QAOlson Drones LLC · Albion, NEN534DCSale Reported · Dawn, MOSale reported, pending cancellationN537DCSale Reported · Arma, KSSale reported, pending cancellationN538DCIreland David · Mankato, MNN549TXMos Aerial Spraying LLC · Osmond, NEN551GRCorunna Public Schools · Corunna, MIN552RLLarson Ryan Ddba · Swea City, IAN553LTAgriflight LLC · Hilbert, WIN553NHHornsby William A · Iron City, GAN560RCRc Agriculture LLC · Burley, IDN5673SSafe Flight Ag LLC · Belton, TXN570NPNo Pack LLC · Towanda, PAN573TGTop Gun Drone Service LLC · Cape Girardeau, MON5805BRegistered aircraftAssigned, pending cancellationN584FCCyclone Agri-Drone LLC · Colo, IAN584SNNix Shawna · Steele, NDN588RBByers Rian A · Spirit Lake, IAN590NANomad Aerial Services LLC · Graytown, OHN596DNMountain View Drone Applications LLC · Mountain Lake, MNN606BDBlack Dirt Repair LLC · Corder, MON608RLNextgen Drone Solutions LLC · Richton, MSN60JRJr Custom Applications LLC · Arthur, IAN6108WWassman Matthew J · Hinckley, ILN619SDSan Diego Gas & Electric · El Cajon, CA
Back to Xag P100 PRO