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 ('2072722')
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 ('2072722')
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.
N3371FRavens Rebuilders Inc · Ellenboro, WVN3372FSwanner Robert Craig II · Water Valley, MSN3375FKintner William R · Port Angeles, WAN3381FAttema Symon Nmi · Norco, CAN3386FN3386f Flying Club Inc · Pickerington, OHN3387FChristensen Robert F · Gillette, WYN3390FRodgers Christian Joseph · Ormond Beach, FLN3391FKingston Terry D · Irving, TXN3396FThompson Patrick J · Evanston, WYN3397FKerns Aaron R · Sullivan, INN3399FVetter T Kevin Trustee · Phoenix, AZN339CPHenley Mark L · Emelle, ALN3400FSpencer Aviation Services LLC · Sanger, TXN3402FTran Dzung V · Las Vegas, NVN3404FJones Jimmy N · Bremond, TXN3407FHoltzinger Tyler · Muscle Shoals, ALN3410FMacy Richard H · Culver, ORN3412FClaretta Inc · Wilmington, DEN3415FGriffith John M · Seatac, WAN3419FSchreib John D · East Troy, WIN341RMRocky Mountain Skydive LLC · La Salle, CON3425FJ A White & Son Aviation LLC · Powder Springs, GAN3428FKcsi Aerial Patrol Inc · Bakersfield, CAN3430FWingeier Dairy Farms · Alto, MIN3433FVapor-Mist Sanitizing Systems · Boca Raton, FLN3435FDickens Frank K · Moncure, NCN3437FYankee Air LLC · Valdosta, GAN3441FLawrence Kam M · Big Bear City, CAN3444FAtwood David E Trustee · Nampa, IDN3445FAltus Aircraft LLC · Taylor, TXN3445SBigfoot Aviation LLC · Shelton, WAN3447FEngh David Trustee · Wickenburg, AZN3448FLarson Peter · Sheyenne, NDN3449FKunkel John A · Pine River, MNN3450FPeeler Max H · Rock Port, MON3451FBonnett Bruce J · Azle, TXN3455FN3455f Aviation LLC · New Blaine, ARN3457FStreet Jim A · Pilot Point, TXN3458FAirport Lounge Mbi LLC · Dayton, OHN3460FCut And Snip Flyers LLC · South Weber, UTN3462FBehrendt Matthew D · Winsted, CTN3463FLee Paula S · Sandpoint, IDN3464FBowsman Barry K · Dowagiac, MIN3466FAgri-Tech Aviation Inc · Indianola, IAN3467FHappy Trails Flight Training & Charters LLC · Helena, MTN3468FLefevre Development Co LLC · Jackson, TNN3471FDel Norte Flying LLC · Del Norte, CON3472FMiller Robert F · Locust Grove, GAN3473FBoone Bruce L · Woodland, CAN3475FSanguinetti Mark · Winnsboro, LA
Back to Cessna 182J