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.
N9552AAmeriflyers Of Texas Inc · Addison, TXN9553ATitusville Aero Club Inc · Titusville, PAN9559DChristiansen Aviation LLC · Wilmington, DEN9559SElizabeth Dloda LLC · Hilton Head Island, SCN9559VOcm Aviation LLC · Buckeye, AZN9560SMoore Justin W · Hollywood Park, TXN9560WGeneral Aviation LLC · Henderson, NVN9561VAbove And Beyond Aviation LLC · Austin, TXN9562PAvolant Aviation LLC · Mooresville, NCN9562QSilverhawk Aviation Academy Oregon LLC · Ontario, ORN9563AChristiansen Aviation LLC · Wilmington, DEN9572WDr Equipment LLC · Ackerly, TXN9577WIasco Flight Training Inc · Redding, CAN9577ZAtp Aircraft 4 LLC · Wilmington, DEN9579VPlaisted Aviation LLC · Elk River, MNN9581GN9581g Corp · Skokie, ILN9710FAtp Aircraft 4 LLC · Wilmington, DEN9713FDhs Operations LLC · Wilmington, DEN9715FPlock Cory J · Southbury, CTN971KCDenventures Aviation LLC · Wheat Ridge, CON972KCMustang Sally Aviation LLC · Camden, SCN9730FN9730f LLC · Boynton Beach, FLN9731FN9731f LLC · Stuart, FLN973BCBattle Creek Flyers LLC · Battle Creek, MIN9741FAa-Aero Inc · Fairfield, NJN9744DTom Wood Aviation Inc · Fishers, INN974BCL & W Aircraft Investment LLC · Homestead, FLN9754FFirst Eclipse Ltd · Richmond, VAN9764FFixed Wing Holding Co Inc · Pembroke Pines, FLN9767FMid Island Air Service Inc · Ronkonkoma, NYN978CPCivil Air Patrol Inc · Maxwell Afb, ALN9791FRedstone Arsenal Flying Activity · Redstone Arsenal, ALN979BCMacinnis Charles E · Harbor Springs, MIN979CPCivil Air Patrol Inc · Maxwell Fb, ALN97LFSpengler Raymond Francis Jr · Longview, TXN980CPCivil Air Patrol Inc · Maxwell Afb, ALN981BCSilverhawk Aviation Academy LLC · Caldwell, IDN981BTPea-Wayman Flight LLC · Daytona Beach, FLN981CPCivil Air Patrol Inc · Maxwell Afb, ALN981WUEastern Kentucky University · Richmond, KYN982BTWings Over Texas Holdings LLC · Denton, TXN982CPCivil Air Patrol Inc · Maxwell Afb, ALN983CPCivil Air Patrol Inc · Maxwell Afb, ALN983RAChristiansen Aviation LLC · Wilnington, DEN983WUEnvoy Air Services LLC · Leipsic, OHN98436Christiansen Aviation LLC · Wilmington, DEN984AVAtp Aircraft 1 LLC · Wilmington, DEN984BTMoore Aviation Inc · Beaver Falls, PAN984CPCivil Air Patrol Inc · Maxwell Afb, ALN984WUMoore Aviation Inc · Beaver Falls, PA
Back to Cessna 172R