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 engine_model_code IN ('34801', '34802')
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 engine_model_code IN ('34801', '34802')
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.
N914PDDamron Danny M · Glen Allen, VAN918HACustom Built Ac LLC · Wilmington, DEN924WTJohnson Douglas · Kent, OHN925GCKemnitz Jonathan L · Minnetonka, MNN925SMcpherson Shawn M · College Station, TXN932RJJud Robert W · Holly, MIN936SXMartin Tommy L · Vancouver, WAN938BAstley Richard · Chico, CAN94246Olebos Noel · Conifer, CON942DHRamos Benjamin C · Woodburn, ORN9449SRichardson Roger L III · West Richland, WAN948XTippitt Robert H · Gulfport, MSN949TFFinley Timothy C · Washington, MON951TTPluard Sean Patrick · Strawberry Plains, TNN9554ZShanks Randal D · Truxton, MON9696Ramos Luis M · Cabo Rojo, PRN9779NZwerg Daniel R · Ocean Springs, MSN979RLBenham Aviation LLC · Enid, OKN979SXMcintire John P · Pittsfield, ILN97RBHilaman Chris T · Oak Hill, FLN989MDDrewry James D · Dayton, TXN990MKKreizenbeck Mack P · Meridian, IDN991CCC&L Aviation Ltd · Maysville, KYN994PCSale Reported · Kingsville, TXSale reportedN999NAPowell Andrew A · Trenton, SC
Back to Jabiru 3300