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 ('9830220')
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 ('9830220')
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.
N444YKSpaar Kenneth E Jr · Solvang, CAN44YKClear Blue Skies LLC · Syracuse, KSN45BSGeipel William R · Woodville, WIN502GCPerformance Aircraft C LLC · Litchfield Park, AZN5113BRoszell Casey R · Mc Calla, ALN520CPWilloughby Peter A · Hendersonville, NCN520LETrinh Ruth · Westminster, CAN524TKYakflyer Aviation LLC · Wilmington, DEN5287Fight'S On! LLC · San Marcos, CAN52BNWark David A · Rochester, NHN52BSYakfiftytwo LLC · Bloomington, MNN52CGFinkelmeier Joachim K · Grosse Pointe, MIN52LFAero Sport Craft LLC · Havre De Grace, MDN52LSHeath Aviation LLC · Ludowici, GAN52VRVr Performance Systems LLC · Louisburg, KSN52YKReiley Hunter W · Harlingen, TXN5874MFerguson Ross L · Stateline, NVN5877HLitvyak Unlimited LLC · Stateline, NVN58GCFarrell Grant B · Lake Forest, ILN58YKNolan John R · Colorado Springs, CON6161TFlying Low Racing LLC · Oklahoma City, OKN6209FKnolla John L · Andover, KSN6213KIverson Steven E · Dallas, TXN6223XGolden Compass Aviation LLC · Wilmington, DEN6294DYoung Michael B · Scottsdale, AZN6397ZGrant Roderick M · Dillingham, AKN6398ZRed X Yak Inc · Troy, OHN666YKLaughlin Richard C Jr · Boerne, TXN694YKBozek Philip T · Brighton, MIN6YKBell 47 Helicopters Inc · Middletown, DEN7057TDen Dulk Arthur F · Hughson, CAN7074LHladik Alexander Thomas · New Smyrna Beach, FLN7092ARegistration Pending · Wasco, CARegistration pendingN7092EGlave William C · Deltaville, VAN7213JAirplanes Of Kankakee Inc · Kankakee, ILN72423Burris Curt B · Marietta, GAN752YKG-Loc Fighters LLC · Wilmington, DEN75507Colvin Clu D DBA · Big Cabin, OKN7694BJohnson Evan J · Albuquerque, NMN77YKHanshew James M · Phoenix, AZN8043EPomeroy George A · Fallon, NVN81FSRed Star Aero Services LLC · Mobile, ALN8252Glaser Scott T · Rosamond, CAN82623Lamprecht Marinus · El Granada, CAN82627Gregory James A · East Burke, VTN8271PKennedy Jared Executor · Waco, TXN829YKMorrison Michael S · Virginia Beach, VAN852GCAraujo Michael Aj · Elesberry, MON85YKAllied Aircraft LLC · Lemon Grove, CAN861YAMccoy Bill · Deland, FL
Back to Yakovlev YAK 52