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 ('2072734')
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 ('2072734')
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.
N1765RPlane Pro Aviation LLC · Shelby, NCN1773RAsher Robert P · Oregon City, ORN1777RKnur Ronald Glen · Elizabeth City, NCN1781RDale Mar Enterprises Inc · Granton, WIN1784RCunning Aviation LLC · La Mesa, CAN1786RWhalen Dann Trustee · San Diego, CAN1800RSugrue Aviation Inc · Silver City, SDN1806RFly By Night Aviation Inc · Pleasantville, NYN1807RVeldman Richard D · Laporte, INN1810RMcdaniel Benjamin G III · Birmingham, ALN1817RLfg Properties LLC · Portage, MIN1818RSideline Services LLC · Pearland, TXN18218All Spark Aviation LLC · Naples, FLN1824RKleissas Constantine · Wye Mills, MDN182BZBaker John J · Tucson, AZN182CFJunell Justin · Zuni, NMN182CWFernandez Miguel A · Merritt Island, FLN182EB182 Flyers LLC · Spartanburg, SCN182GZAircraft By Farkas LLC · Middleburg Heights, OHN182HATurner Company LLC · Hearne, TXN182KSAltivor LLC Trustee · Sheridan, WYN182MJNelson Theresa H · Knoxville, TNN182NCKrizauskas David F · Moncks Corner, SCN182RNNensel Richard E · Sylvania, OHN182UKarl Mark G · Wilbraham, MAN1834RRadford David M · Glen Cove, NYN183BBRussell Charles B DBA · Union City, TNN1857RNoetic Aviation LLC · Seattle, WAN18NJTennessee Dept Of Saftey & Homeland Security · Nashville, TNN20099Wehnam Kenneth J · Shingle Springs, CAN2024SRegistration Pending · Sublette, KSRegistration pendingN202CTIsrael Oscar M IV · Sinton, TXN20448Delta Echo Whiskey LLC · Apopka, FLN20522Sale Reported · Paulista SpSale reported, canceledN2076JEss Trent E · Loretto, MNN2089STxt Aviation LLC · Deland, FLN2114SCochise Community College · Douglas, AZN2134SC Squared Inc · Stevensville, MDN214TJVector Aeromedical Services LLC · Smithfield, NCN2178SAbbey Alyssa · Novato, CAN21PLYankee Flying Club Inc · Maple Grove, MNN220WSClark Alan R · Tucson, AZN222HPHarrison Walter E · Taylor, TXN223BTMull David L · Kathleen, GAN2244TAmerican Elevator · Ruidoso, NMN224ACSellers Scott R Trustee · Racine, WIN2251TGardner Bryan T · Rancho Cucamonga, CAN2257RCanales Jorge · Anthony, NMN225JACoffin Paul · Sioux City, IAN2260TOrtner Airport LLC · Wakeman, OH
Back to Cessna R182