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 ('2072821', '2070107')
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 ('2072821', '2070107')
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.
N8747ZMermaid Marine LLC · Auburn, WAN8750ZArge Aviation LLC · Montana City, MTN8760QCarcioppolo Joseph A · Auburn Twp, OHN8776QRichardson Thomas R · Valleyford, WAN8785ZRegistration Pending · Connell, WARegistration pendingN8786ZNordstrom Hans P · Wasilla, AKN87STTrygg Holdings LLC · Anchorage, AKN8812Zzz Aviation LLC · Newberg, ORN881FDDaneco LLC · Houma, LAN881PRMcdonald William H · Anchorage, AKN8845QJohnson James W · Wilmot, ARN887WBJones Brandon · West Bountiful, UTN888BLBillings Daryl DBA · Henderson, CON888DKCalderon Jose Manuel · Alexandria, VAN8APacific Aviation LLC · Cottage Grove, ORN8WFRegistered aircraftN900JBPumpkin Eater LLC · Tavares, FLN907AKErickson Michael J Jr · Juneau, AKN907CERoss Peter W Trustee · Lufkin, TXN907LMDe Gavere Lambert M · Anchorage, AKN909GBHead West Lake Operations LLC · Dubois, WYN90MWBueter Brandon P · Northville, MIN90SNMortvedt Arthur D Trustee · Manley Hot Springs, AKN9101FSkaw Jack E · New Auburn, WIN9128HEriksson Kurt R · Soldotna, AKN914STAir Ex LLC · Chelan, WAN91DMHead Joseph A · Fairbanks, AKN91MWSub C Air LLC · Spring, TXN91PHJulien John · Houghton, MIN9204HTongass Air LLC · Ketchikan, AKN92503Harper Bryan K · Junction City, ORN9269UDennis Matthew C · Transylvania, LAN926HMWestern Enterprise LLC · Pueblo, CON9294HWet Dreams LLC · Erwinna, PAN92DCAdams Bob L · Eagle River, AKN92WMGerhardt David C · Denver, CON9300NChristensen Hans · Enterprise, UTN93010Davis Russell C · Odessa, TXN93018Joy Austin J Jr · Anchorage, AKN93025Kiesel Edward K · Juneau, AKN93027Indy Air LLC · Blaine, MNN93030Cathey Wacey D · Polson, MTN93033Kaval John P Jr · Duxbury, MAN93039Dorris Michael R · Mccall, IDN93050Wilson Thomas Henry III · Anchorage, AKN93055Moore Joshua M · North Pole, AKN93098Faeo John D · Wasilla, AKN93183Frost John David Trustee · Anchorage, AKN93189Hoppner Theodore · Fairbanks, AKN93202Nature State LLC · Portland, OR
Back to Cessna A185F