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.
N656SPChristiansen Aviation LLC · Wilmington, DEN65729Nevrdul LLC · Cambridge, MDN65738Mc Collom Perry C · Saint Louis, MON65745Mustang Sally Aviation LLC · Camden, SCN65790Horan Peter · North Easton, MAN65795Bank Of Utah Trustee · Salt Lake City, UTN657SPChristiansen Aviation LLC · Wilmington, DEN65841Just Plane Stuff Inc · Jackson, MSN658MACantele Joseph D · Hickory Hills, ILN65956Ameriflyers Of Texas Inc · Addison, TXN659SPChristiansen Aviation LLC · Wilmington, DEN66010Crane William Jr · Somerville, ALN66025Suburban Air Corp · Castro Valley, CAN66046Palm Beach Flight Training Corp · Lantana, FLN66068Phoenix East Aviation LLC · Daytona Beach, FLN66083Bravo Zulu Aviation LLC · Torrance, CAN66085Bellers Aviation Inc · Fremont, CAN660JWLearning 2 Fly LLC · Cave Creek, AZN660SPRobert Devers Solutions · Hermosa Beach, CAN66104Rhb Aviation LLC · New Orleans, LAN662SPCessna N662sp LLC · Duluth, GAN663SPN663sp LLC · Stuart, FLN664CAChristiansen Aviation LLC · Wilmington, DEN667SPHindi David · Cupertino, CAN669FGMustang Sally Aviation LLC · Camden, SCN669PDBarder David A · Millersburg, PAN669TWAlmanor Express LLC · Palo Alto, CAN66LYRapid Fleet II LLC · Carmel, INN670CSSilverhawk Aviation Academy LLC · Caldwell, IDN672EBAviation Associates Of Hanover LLC · Enfield, NHN672SPThomas Bahamas Airways LLC · Port Orange, FLN673SP673sp LLC · Blaine, MNN6745PPinnacle Aviation Services Inc · Encinitas, CAN676CPCivil Air Patrol · Maxwell Afb, ALN677DMAa-Aero Inc · Fairfield, NJN677JARaji LLC · Mclean, VAN678AAWings Over Texas Holdings LLC · Denton, TXN678RBBoldflight LLC · Bargersville, INN678SPFreed Bryan S · Norfolk, VAN678WWFly Cessna LLC · Peoria, AZN67MSAmerican Aviation Inc · Brooksville, FLN680MAChristiansen Aviation LLC · Wilmington, DEN681CPCivil Air Patrol · Maxwell Afb, ALN681MAChristiansen Aviation LLC · Wilmington, DEN682CPCivil Air Patrol · Maxwell Afb, ALN682MAChristiansen Aviation LLC · Wilmington, DEN683CPCivil Air Patrol · Maxwell Afb, ALN683SPNovember 243 Bravo Mike LLC · Castle Rock, CON684SPCondor Aero Club Inc · Zelienople, PAN685SPDirty Side Down Aviation LLC · Georgetown, TX
Back to Cessna 172S