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.
N327UJDelta Wings LLC · Carlisle, ARN329AGAgriflight LLC · Hilbert, WIN329GRCowboy Country Drone Service LLC · Buffalo, WYN329RLSkyspray LLC · Lakefield, MNN332DSSnyders Crop Service LLC · Mount Joy, PAN332KSSchutte Darrell · Kimberly, IDN332LSRaymond Randall C · Grand View, IDN3346KRamseyer Kevin · Poneto, INN334ESAg Pro Drone Service LLC · Corunna, MIN334RBFlokstra Andrew T · Marshall, MIN335EESale Reported · Homer, MISale reportedN335TRCk Helicopters LLC · Jasper, INN336TXMidwest Crop Solutions LLC · Carlisle, IAN337QAAirstrike Ag LLC · Barnum, IAN337TASobotka Farms LLC · Laurens, IAN338JHenningsen Ag Service LLC · Walnut, IAN340NAAg-Tech Drone Service LLC · West Jefferson, NCN340RMMarlatt Rick · Wood Lake, NEN340USStratton Air And Ground LLC · Tulare, CAN342RLTrue Path Application LLC · Atmore, ALN345DMSykes Southern Acres · Crawford, MSN3552Back 40 Drone Services LLC · Marceline, MON355EEJm Ag Service LLC · Durand, MIN361RKPrairie Vu Drone Services LLC · Bethany, MON3620AMs Custom Application LLC · Lehigh, IAN362RKPrairie Uv Drone Services LLC · Bethany, MON3631A4g Spraying LLC · Potter, NEN3632G4g Spraying LLC · Potter, NEN363ASSchutte Darrell · Kimberly, IDN363DCWampum Unmanned Technologies LLC · Tulsa, OKN363DHDosbro Holdings LLC · Ashford, ALN363YHHeritage Ag LLC · Kentland, INN3645KKusak Lee · Franklin, TXN364PPPrecision Soil Consulting LLC · Des Moines, IAN365YSUav Ag Solutions LLC · Oakdale, CAN367KSSykes Southern Acres · Crawford, MSN368HWWeakley Farmers Co-Op · Martin, TNN368KBBlake John · Earl Park, INN369HLAgra Drone Solutions LLC · Columbus Grove, OHN370CXWosely Ag Service LLC · Sibley, IAN370DXIowa Aerial LLC · Manson, IAN370FFFischer Jarrett DBA · Cory, INN370GTIndiana Ground Tech LLC · Boggstown, INN371AAAirstrike Ag LLC · Barnum, IAN371XTTriple M Poultry Farm LLC · Tylertown, MSN3749SSwift Drone Technologies LLC · Benson, MNN3755FHarper Adam P · Moorefield, WVN376JHHealthy Acres Aerial Applications LLC · Martin, MIN376MFPage Travis · Carlisle, INN3801SQuake Zone Agridrone LLC · Portageville, MO
Back to Xag P100 PRO