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 ('55566')
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 ('55566')
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.
N58RMProcter P Richard · Statesboro, GAN5949YCroft Jeffrey W · Tennessee Colony, TXN599WDDence Lavern W · Glen, MSN59MFFuller John M · Duanesburg, NYN60101Obrien Kevin J · Dunedin, FLN6048XGilbert Kent G · Brookshire, TXN6052EBryan Andrew · Eureka, CAN605DHLuedders And Reed Inc · Pawnee City, NEFirst renewal noticeN6080MCottrell Larry J · Jordan Valley, ORN608VSSensenig Vicki L · Tucumcari, NMN609GPMcnulty Gary J · Oroville, WAN610REElder Matthew C · Raymond, MEN6110RWhite David S · Holcomb, MSN61118Hohne Paul C · Westminster, MDN6115YSanchez William J · Long Beach, CAN6116ZPerdew Paul · Mc Farland, WIN6118NPenry Richard E · Daphne, ALN61211Evolution Aircraft Inc · Zephyrhills, FLN6123EDeleeuw Douglas J · Toms River, NJN6129QKoehl Jim M · Cropsey, ILN612NCSchumacher Michael E · Sidney, ILN613MDGorell Loren G · Cadott, WIN6147XRoscoe George M · Melbourne, FLN61515Rowlands Robert W · Athens, TNN61529Labar Randy A · Gaines, MIN6153Highsmith Michael D · Chipley, FLN6153XWatkins Jonathan Trustee · Florence, ORN6154RMartucci Dennis J · Monroe, GAN61592Henshaw Thomas C · Kent, NYN61634Daus Charles J · Imler, PAN6170DFowler Arthur · Erie, CON6173BLong Johnny P · Trussville, ALN6176CChilds Robert A · Salisbury, MDN6180HJohnson Kelvin · Glasgow, MTN620WCAnderson Jason W · Eau Claire, WIN6220SPhipps David M · Belleville, ILN623LYJanotka Kameron R · Chesapeake, VAN626KWPhillips Joshua D · Sylvania, GAN62CPPaterson Christopher · Las Vegas, NVN62ETNelson Edward T · Silver Springs, FLN630PHOwens Ralph P · Carson City, NVN64326Hubbard Chase L · Necedah, WIN643RPBolles Bruce J · Lake Elmo, MNN65083Siess Tye G · Hot Springs, ARN650GBungard Neil J · Vail, AZN65763Ferguson Michael D · Mendon, MIN657SBNear Thomas C · Lawrence, KSN65QCGingerich Daryl P · Dayton, VAN662MTyre Danny J · Hahira, GAN6630QCambon William R · Joshua Tree, CA
Back to Rotax 503 DCDI