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 ('06102HG', '06102IE')
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 ('06102HG', '06102IE')
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.
N125CRCr Agworks LLC · Cisne, ILN125NAOn The Fly Agriworks LLC · Goldsboro, NCN125TDRegistered aircraftAssigned (non-type certificated), pending cancellationN126ACRegistered aircraftN-number assigned, not yet registeredN127EEA & H Forestry LLC · Sherwood, ORN127LRL&R Ag LLC · Breese, ILN1280Roger Puterbaugh LLC · Cavour, SDN12CBC&B Grain LLC · Rochester, INN13066Jdv Farms Inc · Prairie City, IAN1319Goranson Drone Services LLC · Red Oak, IAN132CRCr Agworks LLC · Cisne, ILN133BLB & L Aerial Ag LLC · Riverdale, MIN133EEBurnin Daylight Ag Drones LLC · Copan, OKN134EEIndian Creek Ag Drones LLC · Ringwood, OKN1350MCrawford Jim · Pocasset, OKN139JFBowen John · Ainsworth, NEN141TSRaab LLC · Centerburg, OHN1427Jensen Ag Inc · Hampton, NEN142DDSouthern Drone Applications LLC · Winnfield, LAN143DAJarrell Flying Services LLC · Okolona, MSN143KARegistered aircraftAssigned (non-type certificated), pending cancellationN144JFTernus Aerial Application LLC · Genoa, NEN144NDSale Reported · Evansville, WISale reportedN145AGAg Pro Solutions LLC · Creston, IAN145PFP & F Drone Services LLC · Damon, TXN1467ADrone Agri Spray LLC · Park Falls, WIN1482WThompson Drone'S LLC · Monona, IAN14830Captured Ag LLC · Providence Forge, VAN148ATAtb Special Purpose LLC · Laredo, TXN150DCIbendahl Joshua D · Nashville, ILN151TBBrooks Michael Shane · Wetumka, OKN1521MR & R Drone Application Services LLC · Crowley, LAN1534R3 Ag LLC · Gladstone, ILN153BNPin Oak Enterprises LLC · Greenville, ILN157DSDrone Spraying Solutions LLC · Marshall, ILN157LCLinn Cooperative Oil Co · Marion, IAN1581EMcgrew Brothers Farms · Emerson, IAN1582LMcgrew Brothers Farm · Emerson, IAN159YDYellowstone Drone Solutions LLC · Hysham, MTN1602TTs Agricultural Drone Services LLC · Everett, PAN1620FFrahm Lon R · Colby, KSN163AGAg Pro Solutions LLC · Creston, IAN16471Schroeder Ag Precision Drones LLC · Clarence, IAN164MMMiller Mitchell W · Cisne, ILN165BABecker Ag Service · Keystone, IAN167BCHelton Enterprises LLC · Century, FLN16LZArmstrong Ag Services LLC · Windthorst, TXN1719Precision Drone Application LLC · Cascade, IAN171KBD&D Agridrones LLC · Junction, ILN17640Drone Crop Dusting LLC · Comanche, OK
Back to DJI AGRAS T50