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 ('2072716')
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 ('2072716')
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.
N3770UPetersen Christopher Erik · Morton, ILN3776USchmit Joe · Ventura, IAN3778UBlue Goose Aviation Inc · Polson, MTN3779UWhittom Ronald W Jr · Wasilla, AKN3782UOttmer Mark L · Pearce, AZN3787UCcd Aviation LLC · Gardnerville, NVN3791UHarway Inc · Rockingham, NCN3793UFly Direct Inc · La Porte, INN3798UClapper Wesley J · Spokane, WAN382SMJones Darrel E · Sonoma, CAN40AESchwartz Michael · Missoula, MTN41130Chapa Jana K · Corpus Christi, TXN452JSOffroad Aviation LLC · Las Vegas, NVN4944PReed John Richard · Charleston, ILN49GPMartin Dale · Lubbock, TXN5035TJettime10 LLC · Grayslake, ILN515CLProfessional Pilot Services LLC · Miami, FLN55SNHussey Arthur M III · Fairbanks, AKN61JRSawyer Mark S · Simi Valley, CAN61YHamilton Daniel L · Coleman, OKN628DKEastgate Investments LLC · Henderson, NVN648FRegistered aircraftN64RKKoril Richard A · Overgaard, AZN67236Cessna N67236 LLC · Harrah, OKN6999MAbonil Ty · Philadelphia, PAN6DNLowery William D · Geneva, FLN6QTM And K Industries LLC · Anchorage, AKN75MLLowe John Howard II · Tifton, GAN78FGMcclanahan John B · Fayetteville, GAN81TJHelgerson Nicky A · Zwingle, IAN82488Simpson Patrick E · Ketchum, IDN825SQuamme Eric P · Peachtree City, GAN8292SStephens Ralph W · Reno, NVN82BGGrimshaw Brian Trustee · Long Beach, CAN8EKWindermere Wings LLC · Altamonte Springs, FLN907GGGleim Education Inc · Gainesville, FLN914AVNorcal Skydiving LLC · Cloverdale, CAN993DWDeadstick Holdings LLC · Laguna Niguel, CAN9964CTakle Management LLC · Bethany, OKN99SHRegistered aircraftN9BTParlin Troy W · Wills Point, TX
Back to Cessna 182G