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 ('2071816')
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 ('2071816')
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.
N6294SErmel Ryan · Taylor, PAN6299SSena Gregori C · Buckeye, AZN6301SAbercrombie Michael J · Eureka, CAN6304SCowey Kevin M · Pittsburgh, PAN6305SPrivette Hugh T Trustee · Colorado Springs, CON6309SRegistered aircraftN6315SDelta Delta Aviation Group Inc · New Castle, DEN6316SGlobal Navigator LLC · Anacortes, WAN6321SStoker Dana R Trustee · Tucson, AZN6324SKleis Richard L · Zwingle, IAN6325SConfer Mark A · Fort Wayne, INN6327SHayton James B · Sedro Woolley, WAN6330SErnst Albert S III · Buda, TXN6333SVano Andrew · Carlos, MNN6339SDamico Thomas J · West Bend, WIN6348SSexton Kenneth Wade · Baker, FLN6349SMazzarese Nicholas · Cedar Hills, UTN6355SLudmerer Victor J · Greenwood Lake, NYN6356STurner Dale W · Moore Haven, FLN6361SSchade Scott · Green Valley, AZN6362SMott Charles A Jr · Chesapeake, VAN6363SSnell Matthew L · Ackerly, TXN6367SLogtime Flight LLC · Lancaster, TXN6368SMommsen Robert V · Ketchikan, AKN6377SVillalba Raymond · Spring, TXN6379SMcdonald Gregory S · Mena, ARN6383SNightingale Matthew · Rancho Cucamonga, CAN6384SSalter William Jeffrey · New Smyrna Beach, FLN6385SPalmer Dana G · Gatesville, TXN6390SStraub Aircraft Holdings LLC · Overland Park, KSN64BBBlazey Brian I · Palmyra, NYN67GRQuinlan Sherman L · Georgetown, TXN69HGPlane Fun Inc Tr Trustee · Snellville, GAN6EKCjh Aviation LLC · New Bern, NCN707MTams LLC · North Las Vegas, NVN714JPCp Aviation Inc · Santa Paula, CAN721CWFischer Alfred M DBA · Genoa City, WIN727BSHorvath Andrew J · Winnsboro, SCN727HMPatterson Casey Paul · Kinston, ALN7357FLittle Bird Airways LLC · Hamburg, NYN73JKGolden Jerry W · Ocean Springs, MSRegistration ineffective or invalidN746DGVolkernick Peter A · Rumford, MEN761MAWilliams Charlie · Trenton, SCN762MAGiovannetti Peter C · Fond Du Lac, WIN7STFairley Dustin L · Fairbury, NEN80PPN80pp LLC · Titusville, FLN823WSMcinturf Paul A Jr · Childress, TXN8303JFodero Jesse G · West Seneca, NYN8310JWerth Thomas A · Seattle, WAN8311JD T Flying Inc · Okeene, OK
Back to Cessna 150G