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 ('55562')
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 ('55562')
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.
N582JPRegistration Pending · Carmel, CARegistration pendingN582KSSaltz Robert M · Lewisburg, TNN582PQButler Teresa T · Florence, ALFirst renewal noticeN582PSSparks Ralph Lee · Mc Alpin, FLN582RBBurns Rickey D · Cedartown, GAN582SDDalton Steven P · Conyers, GAN582SWCarver Jason · Fallbrook, CAN582TFFarr Thomas C · Marcy, NYN582ULMorrow Ray A · Baton Rouge, LAN583HWMerrill Steven W · Proctor, MNN58KPPurdy Kenneth E · Columbus Junction, IAN595JHTaylor William L Sr · Shelbyville, TNN59BPRedford Dale A · Safford, AZN5QUMccormick Christopher · Columbus, OHN60393Harger Kenneth G · Rosharon, TXN6050NHarlan Brian C · North Pole, AKN6059FWinegarden Steven P · Sunnyvale, CAN6062UTaylor Dan F · Dallas, GAN6096QFanning Dan W · Frederick, CON609VTHarris Christopher · Albuquerque, NMN60XLJacobs Justin C · San Francisco, CAN6126XSay Douglas A · Farr West, UTN612DDFraser John R · Chelsea, VTN61307Press Richard · San Bernardino, CAN6133SJakoubek Kirk D · Valles Mines, MON6140ADecker Henry W · Hague, VAN6142RDrury Neil · Deland, FLN615TBBolstad Terry F · Bayview, IDN6163GDaus Charles J · Imler, PAN6166YWitt Frank L · Cedar Lake, INN620KLLienke Kevin · Beaver Dam, WIN628YBruns Brent D · Saint Joseph, MNN630VMHeatherly Charles C · Elizabethtown, NCN6417Tribble Keith P · Orlando, FLN644VWright David L · Safford, AZN646JHElkins Robert E · Manawa, WIN647ACBerger Raymond C · Tigard, ORN648GHDaniels Larry F · Elyria, OHN6503XEckhardt Stephen D · Puyallup, WAN6504FCoshow Bradley S · Niles, MIN65106Stanczak Michael L · Saint Charles, MON6512PForburger Jerry J · Idalou, TXN65294Rainwater Michael · Center Point, ALN6529GLinn James B · Ripon, CAN6536ZBrumfield Michael A · Tylertown, MSN65384Thompson Ronald K · Walnut Cove, NCN65425Renschler Clifford L · Tijeras, NMN65678Whitley Wesley B · Sun Prairie, WIN65682Edmison Robert J · Columbus, NEN65736Clare Alan V · Maiden Rock, WI
Back to Rotax 582DCDI