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.
N2729FSexton & Sanders Law Firm Pa · Fort Smith, ARN2733FMetzger William M · Boonville, INN2734FWard Christopher C · Lufkin, TXN2743FRiddle Danny M Trustee · Ruby Valley, NVN2744FTyson Jacob N · Molena, GAN2749FSummersell Chadwick G · Chattanooga, TNN2751FAzuris & Co · Albuquerque, NMN2752FSchoppaul David · Anthem, AZFirst renewal noticeN2754FOtter Mark E · Warrensburg, MON2757FNationwide Web Directory Ltd · Seattle, WAN2762FFreflite LLC · Wilmington, DEN2763FSeawings LLC · Holualoa, HIN2765FStoup Lyndal K · Cordell, OKN2766FBrach Raymond S · Henderson, NVN2769FMatthews George W · Hillsboro, OHN2770FEmmons Jack E · Elizabeth City, NCN2773FAdriatic Holdings LLC · Cheyenne, WYN2775FJock Carl A Trustee · Roscommon, MIN2776FBabovic Slobodan · Elm Grove, WIN2778FHuber George M · Bentonville, ARN2779FSweatt D Wayne · Memphis, TXN2782FMansoori Ali S · Aurora, CON2783FVspp Consulting LLC · Stevensville, MDN2785FAugustin Lyn H · Saint Thomas, NDN2786FChristoph Nicolas T · Okanogan, WAN2787FWammen Gil V · Reva, SDN2788FShryock Patrick D · King Salmon, AKN2792FRoshong Loman · Leesville, LAN2795FRegistration Pending · Marietta, GARegistration pendingN2796FX-Ray Engineering Corp · Port Orange, FLN2797FWhatley Charles J · Goliad, TXN2800FMeyer Scott R · Palm Harbor, FLN2802FC-All Mfg Inc · Atoka, OKN2804FChristensen David W · Lyman, UTN2809FOverbaugh Gary R · Highland, UTN280HB280hb LLC · Brighton, MIN2810FDancing On Blue Lc · Las Vegas, NVN2811FLien Craig C · Plains, MTN2813FDan Air LLC · Greenville, SCN2818FMccullough Andrew · Lubbock, TXN2825FStephens Jeffrey G · Gig Harbor, WAN2828FSmiley Neil J Trustee · Lake Havasu City, AZN2835FAdams Stephen L A · Fortuna, CAN2836FPaul Jr Johnny D · Camden, SCN2840FMendive Richard J · Priest River, IDN2841FDrago Gene Kirk · Bainbridge, GAN2842FKuhns Robert A Trustee · Geneseo, ILN2844FN2844f LLC 0421 · Valentine, NEN2846FA-Z Aviation LLC · Bay City, MIN2849FPrice Marvin H · Roseburg, OR
Back to Cessna 182J