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 ('2072708')
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 ('2072708')
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.
N8511TAcute Holdings LLC · Jenks, OKN8512TRegistration Pending · Odessa, TXRegistration pendingN8514TCombee Ann W · Winter Haven, FLRegistration expired, pending cancellationN8515TGraham Richard · Farmingdale, NYN8517TWahl John Jr · Yelm, WAN8522TWicklander Richard O · Spanaway, WAN8523THorning Jason R · Seffner, FLN8524TMurlin David · Hemet, CAN8525TSmith Randall M · Escondido, CAN8526TJoachim Barry L · Lubbock, TXN8528TLonni Rasmussen · Lehi, UTN8530TZakis Stephen · Hillsdale, WYN8531THarms Reuben S · Jackson, GAN8533TAirmotive Service LLC · Brigham City, UTN8534TCoonrods Garage LLC · Dodd City, TXN8539TCorbitt James Todd · Irvine, CAN8540TLoge Pilot LLC · Walker, MNN8541TShepard Robert B · Minden, NEN8544TRose Don G · Winnsboro, TXN8546THoopes Aviation LLC · Carey, IDN8549TGagnon Nels D · Globe, AZN8554TDrake Robin G · Loganville, GAN8559TNorstegaard Mark A · Sturgis, SDN8560TMcmaster John DBA · Wichita, KSN8561TScriver Cody M · Vashon, WAN8564TSpeer Gary L · Knoxville, TNN8565THarris Spraying Inc · Circle, MTN8566TWiggins Jeffrey W · Norwood, NCN8570THeuett Clint James · Asotin, WAN8572TAerial Wayfarer LLC · San Antonio, TXN8579TGoldschmidt Scott · Cottonwood, CAN8580TBas Part Sales LLC · Greeley, CON8585THancock Jeff · Jacksonville, TXN8586TKuntz Randy P · Belfield, NDN8588TBaker Delbert W · Shelton, WAN8590TSecker-Walker Hugh E · Newburyport, MAN8591TRegistered aircraftN8598TFoster Jacob D · Parker, CON8599TRegistered aircraftN8601TSmalley Roger A · Medford, ORN8602TReed James E · Inverness, MSN8603TBaldwin Glen R · Culdesac, IDN8604TAircrafters LLC · Tucson, AZN8606THh Leasing Corp · Jacksonville, FLN8607TLynden Flying Club Inc · Lynden, WAN8609TSloan David J · Anchorage, AKN8610TMusser Craig A · Linden, PAN8613TDorough Luke L · Anchorage, AKN8614THodgdon Theodore A · Danbury, CTN8616TSpung Cameron · Ranchos De Taos, NM
Back to Cessna 182C