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 ('5870208')
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 ('5870208')
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.
N6099QBas Part Sales LLC · Greeley, CON611BRKnick Michael J · Camarillo, CAN6200UWhatley Equipment Co Inc · Van, TXN6202UHolmes Richard · Provo, UTN6205UAdams Claude T Jr · Palmer, AKN6207ULatimer Mark A · Roanoke, TXN6208UMurphy Larry S · Bullhead City, AZN6212UEwart Douglas G · Kansas City, MON6213UVan Zyll De Jong Sean M · Keenesburg, COFirst renewal noticeN6218UEkstrum Eric · Mound House, NVN621CBAnderson Roger F · Tigard, ORN6220UBarnes Dennis W · Saint Joseph, MON6221UScott Terry · Panama City, FLN6223UHernandez Acosta Rodrigo Alejandro · El Paso, TXN6224UConti Daniel · Leonardtown, MDN6227UVan Tilborg Dale W · Abilene, TXN6229UMonte Sam A · Bend, ORN6230URutter Bruce W · Ralph, MIN6234UNabert Maher K · Augusta, GAN6237UCardoza Roger A · Fairbanks, AKN6240ULewis Ricky Ll · Cisco, TXN6241UPalmer Charles L · Huntington Beach, CAN6244UHawthorn Seth A · New Vienna, OHN6245UMcgee Joel M · Woodford, VAN6247USchaefer John A · Liberty Hill, TXN6250UAsb Jones Aviation · Uniontown, OHN6254UDavis Steven Lynn · Hebbronville, TXN6255UMcclure Garnet · Frankston, TXN6257URippey Barrett F · Chandler, AZN6258UMaricopa Aircraft Inc · Tucson, AZN6260UMoran Peter J · Como, MSN6268UBlair Management Holdings LLC · Carefree, AZN6269UKetola Keith C · Seaside, CAN6270UFarrah Steve · Northlake, TXN6273UButsky Gary C · Livonia, MIN6274UEaves Christopher C · Salt Lake City, UTN6275USityar Frank A · Aptos, CAN6276UKummer Nicholas T · Wenatchee, WAN6278UHarney Michael E · Alta Loma, CAN6281UPavon Francisco J · Boerne, TXN6283UKeithley Roger L · Denver, CON6287UBendure Ryan R · Brighton, CON6289URegistered aircraftN6290UCarney James A · Dallas, TXFirst renewal noticeN6292UCherry Creek School District No 5 · Greenwood Village, CON6293UCairn Holdings LLC · Highlands Ranch, CON6294ULamontagne Brian D · Wyandotte, MIN6295URawareo LLC · Warsaw, MON62CFHolochwost Anthony T · Auburn, CAN62DXGlasford John T · Rapid City, SD
Back to Mooney M20C