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 ('2072418')
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 ('2072418')
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.
N73516Aviation Captial Management LLC · San Jose, CAN73519Usaeroflight LLC · Greenville, SCN73524Dramstad Flying Service LLC · Helena, MTN73525Magras Michael G Trustee · Sahuarita, AZN73530Saffron Aviation LLC · Cookeville, TNN73531Alcione LLC · Miami, FLN73535Magnusson Michael J · Munnsville, NYN73560Gospel Ministries International Inc · Collegedale, TNN73562Steiger Michael P · Cypress, TXN73563Hamms Lake Development Inc · Crown Point, INN73565Thompson Teresa M · Grants Pass, ORN73573Sullins Tyler L · Boerne, TXN73574Wingsleasing LLC · Wichita, KSN73577Benton Frederick N · Weed, CAFirst renewal noticeN73579Officer Properties LLC · Broken Arrow, OKN73581Beaumont Ladonna L · Athol, IDN73585Anderson Dale S · Corona, CAN73596Russellville Aviation Inc · Russellville, ARN73601Flex Air Holdings Inc · San Diego, CAN73603Davis Kevin L · Lodi, CAN73604Registration Pending · Raleigh, NCRegistration pendingN73605Jkg LLC · Murfreesboro, TNN73610Stroup David L · Pottsboro, TXN73618Ace States South West LLC · Stanton, TXN73619Jones & Co LLC · Londonderry, NHN737YT80075 Aircraft Corporation LLC · Wilmington, DEN73PPArew Aviation LLC · San Tan Valley, AZN741DPPleasant Aviation LLC · Mount Pleasant, TXN747PTPrince Paul D · Spring Hill, FLN747VHAmerican Patrols Inc · Midland, TXN74DMT C Rian Association LLC · Grove, OKN74JPGulf Coast Helicopters Inc · Pearland, TXN74PESkycrafters Incorporated · Johnson City, TNN750YTwo Bar Aviation Inc · Lincoln, NEN755PR101 Flight LLC · Waterford, MIN757LELake Elmo Aero LLC · Lake Elmo, MNN757MK101 Flight LLC · Waterford, MIN759STraining Planes LLC · Tampa, FLN75SDVimco N75sd LLC · El Paso, TXN76172Rjd Flight LLC · North Canton, OHN761LAIowa Lakes Community College · Estherville, IAN764AAWings Over Texas Holdings LLC · Denton, TXN764BKFairmont State University · Fairmont, WVN766CPCity Of Cleveland · Cleveland, OHN76HJAmalong Timothy M · Tucson, AZN76JAJahawk Leasing LLC · Sugar Grove, ILN76SSNorth Texas Aeronautics LLC · Burleson, TXN77222Davis Sam Alan · Wendell, NCN773AKKlausler Andrew T · New Market, MNN775MCAmerican Patrols Inc · Midland, TX
Back to Cessna 172M