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 ('2210302', '2210400')
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 ('2210302', '2210400')
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.
N404TWRobison Dave · Roberts, IDN405Burklund Joel H · Minneapolis, MNN40HUMoore Charles B · Miles City, MTN40YLMeggers Roger D · Baker, MTN419WPHole Jeffrey Wayne · Stockton, CAN41BKAmerican Classic Aero LLC · Kalispell, MTN426Jarrett Franklin · Ivyland, PAN44HUFritsche James G · Greenleaf, WIN475GPBig Sky Communication & Cable Inc · Billings, MTN49347Bryant Otto LLC · Conway, ARN49348Benner Tristen · Opheim, MTN49349Rankin Ty · Amarillo, TXN49353Skye Equipment LLC · Asheboro, NCN49354Staple Three Sheep Co · Midwest, WYN49357Miller Blaine Nathan · Brooks, GAN49359Low Go Flyers Inc · Jonesville, LAN49362Schubert Paul · Raleigh, NCN49363Back Country Aviation LLC · Kalispell, MTN49365Mcdonald Ryan James · Chelan, WAN49366Kellogg John H · Skaneateles, NYN49367Hammock Flying Service Inc · Smithville, ARN49370Powell Weston G · Washoe Valley, NVN49371Hebert Max C · Hartstown, PAN49372Walker Scott E · Fort Collins, CON49383Husky 383 LLC · Lafayette, LAN496MGRippy Gregg P · Glenwood Springs, CON4HULevy Robert L · Echo, ORN4QRBrowne Thomas Juan · Grass Valley, CAN500HURower Gary · Brooks, GAN504JMLipscomb Tate Douglas · Anchorage, AKN50HURovegno Paul C II · Burlington, NCN51HUTeton Aircraft Sales LLC · Jackson, WYN537MMMarshall Aviation Services Inc · Elkhart, INN541AEHodgson Jerome D · Live Oak, FLN5QABear Canyon LLC · Afton, WYN5QRC B Equipment · Pell City, ALN5QTHusky5qt LLC · Scappoose, ORN5XA47 Yankee LLC · Bellaire, MIN6076MRomano Victor J Jr · Wasilla, AKN6083USouthern Aircraft Consultancy Inc Trustee · Casper, WYN6085SSkyline Soaring Club Inc · Front Royal, VAN6086UStearman Air Tours Inc · Gatesville, NCN6087UN6087u LLC · Homestead, FLN6088UPotter Timothy E · Murfreesboro, TNN60BEGunn Glenn R · Clearwater, FLN60HUOne Pft LLC · Denton, MTN612BEFulltron Aviation LLC · Springfield, MON627PTaylor Terry · Dickinson, NDN63CTSmith Glenn C · University Place, WAN63FEFour Macs Logistics LLC · Houlka, MS
Back to Aviat A-1