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 ('2072439', '2072442')
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 ('2072439', '2072442')
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.
N562ACN91934 LLC · Evergreen, CON562AEL-Bird LLC · Hood River, ORN562AFMustang Sally Aviation LLC · Camden, SCN562FElite Approach LLC · Chesterfield, MON562NDSpartan Education LLC · Tulsa, OKN563FAWang Yuemin · Wauconda, ILN563NDAerosim Academy Inc · Sanford, FLN563SPSloan Joseph · Lancaster, CAN564ATMustang Sally Aviation LLC · Camden, SCN564MCB Air Lc · Sikeston, MON565ADPhoenix East Aviation LLC · Daytona Beach, FLN565NDAerosim Academy Inc · Sanford, FLN565SPLlp Leasing Group LLC · Lewes, DEN5667KSmith John L · Renton, WAN566DDeland Aviation LLC · Deland, FLN566NDCoast Flight Training And Management Inc · San Diego, CAN566SPLlp Leasing Group LLC · Lewes, DEN567AAAoa Kissimmee Inc · Kissimmee, FLN567DDAir America Flight Center LLC · Daytona Beach, FLN567JWKingdom Power And Glory LLC · Colorado Springs, CON567NDMoore Aviation Inc · Beaver Falls, PAN568NDAerosim Academy Inc · Sanford, FLN569FGMustang Sally Aviation LLC · Camden, SCN569NDVertol Systems Co Inc · Destin, FLN569RJNational Training I LLC · Wilmington, DEN569SPGlobal Flight Training Solutions Inc · Immokalee, FLN570JAJ A Flight Services LLC · Sugar Grove, ILN570NDAerosim Academy Inc · Sanford, FLN570SPOne Seventy To Delta LLC · Scottsdale, AZN571BWBridgewater State University · Bridgewater, MAN571JAJa Flight Services LLC · Sugar Grove, ILN571NDVertol Systems Co Inc · Destin, FLN571SPChristiansen Aviation LLC · Wilmington, DEN572BWBridgewater State University · Bridgewater, MAN572JAJ.A. Flight Services LLC · Sugar Grove, ILN572NDAerosim Academy Inc · Sanford, FLN572SPOld Friend Air LLC · Junction City, ORN573NDAir Shares LLC · Casper, WYN574NDSunrise Aviation Inc · Ormond Beach, FLN575NDAir Shares LLC · Casper, WYN575SPCharlie Leasing LLC · Green Bay, WIN575YSilverhawk Aviation Academy LLC · Caldwell, IDN576NDAerosim Academy Inc · Sanford, FLN576SPSo Cal Leasing LLC · El Cajon, CAN577FAN577fa LLC · Redondo Beach, CAN577NDAir Shares LLC · Casper, WYN577SPTexas State Technical College · Waco, TXN578CAChristiansen Aviation LLC · Wilmington, DEN578MCChristiansen Aviation LLC · Wilmington, DEN582LPCape Island Aviation LLC · Millville, NJ
Back to Cessna 172S