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 ('2072401')
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 ('2072401')
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.
N933LAMindy Limited LLC · Muscatine, IAN9344FAtp Aircraft 2 LLC · Wilmington, DEN9348FDirty Side Down Aviation LLC · Georgetown, TXN934MT8th Dimension Enterprises LLC · Englewood, CON9373FDirty Side Down Aviation LLC · Georgetown, TXN9379FAtp Aircraft 1 LLC · Wilmington, DEN937DRStratton Michael C · Hermiston, ORN9392FBas Part Sales LLC · Greeley, CON9404FBas Part Sales LLC · Greeley, CON9417ZAmerican Aviation Inc · Brooksville, FLN9421ZL&W Leasing LLC · Smyrna, TNN9424FOwens Mark T · Zionsville, INN9435ZChristiansen Aviation LLC · Wilmington, DEN9448ZAmeriflyers Of Florida LLC · Addison, TXN944KCMustang Sally Aviation LLC · Camden, SCN944LAMindy Limited LLC · Muscatine, IAN9453ZMoody Bible Institute Of Chicago · Spokane, WAN9482ZChristiansen Aviation LLC · Wilmington, DEN9485ZAtp Aircraft 1 LLC · Wilmington, DEN94JABeaver Aviation South Inc · Fort Myers, FLN9501FPacific States Aviation Inc · Concord, CAN9501WAwwad Mamdouh A · Walnut Creek, CAN9508WUniversity Of Alaska Anchorage · Anchorage, AKN9511DEglin Aero Club · Eglin Afb, FLN95129Texas State Technical College · Waco, TXN9512FGeorge'S Aviation Services Inc · Honolulu, HIN9515QVictory Aviation Club Inc · Hamilton, OHN9515SKingsky Flight Academy LLC · Lakeland, FLN9516JEastern Kentucky University · Richmond, KYN9520DHodge Flight Services LLC · Pittsburg, CAN9520WAmeriflyers Of Texas Inc · Addison, TXN9522ADunn Legacy Inc · Saint Petersburg, FLN9522SSnohomish Flying Service Inc · Snohomish, WAN9525VFirst Eclipse Ltd · Richmond, VAN9526GAtlas Aviation Tampa Inc · Tampa, FLN9528WWings Over Texas Holdings LLC · Denton, TXN9529WFlight Operations Aircraft LLC · Wilmington, DEN9531DAtp Aircraft 4 LLC · Wilmington, DEN9536DCalifornia Management And Consulting LLC · North Hollywood, CAN9537QBoeing Empolyees Flying Assn · Renton, WAN953ACConeburripul Corp · Miami, FLN9543PHerr Bridget J · Boles, ARN9545FEastern Cincinnati Aviation Inc · Batavia, OHN9547WWatch Ya Head Aviation I LLC · Zionsville, INN9548WZh Aviation LLC · Wilmington, DEN9549FJogger Industries LLC · Sherwood, NDN954ACAir Future Airways Corp · Miami, FLN9550GCopper Skies Aviation LLC · Mesa, AZN9550QDecatur Aero Club Inc · Decatur, ILN9550SBald Eagle Enterprises Inc · Nashville, TN
Back to Cessna 172R