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 ('2076702', '2076704')
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 ('2076702', '2076704')
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.
N1980MMaverick Aircraft Leasing LLC · North Little Rock, ARN1KDDuncan Aviation Inc · Lincoln, NEN1MMN1mm LLC · Seattle, WAN1PXC & C Aviation LLC · Worcester, MAN2010FAircraft Trust & Financing Corp Trustee · Wilmington, DEN2022KMagnolia Air LLC · Adel, IAN202RLDoc Sugar Master LLC · Daingerfield, TXN211CL10-2-4 Aviation LLC · Dallas, TXN211DDCatia Resources LLC · Garden City, TXN212CECal Enterprises LLC · Missoula, MTN212HFGopher Air LLC · New Richmond, WIN212LTTango Squared LLC · Fort Worth, TXN216BGBrasfield & Gorrie LLC · Birmingham, ALN21LHBda Air LLC · New Castle, DEN220LERaythom LLC · Wilmington, DEN220VPCjsmhc 1 LLC · Encinitas, CAN221VPPicabo Leasing LLC · Picabo, IDN224JWSouthern Multifoods Inc · Jacksonville, TXN224KDK-D Leasing Inc · Scottsdale, AZN227MCMatsco Inc · Wilmington, DEN227PXPaxair LLC · Phoenix, AZN227VCTexas Aircraft Lft LLC · Austin, TXN227VROneflight Jets Inc · Englewood, CON230DFVector Design Group LLC · Jeffersonville, INN233XLVanguard Jet LLC · Georgetown, TXN237EELes Schwab Warehouse Center Inc · Bend, ORN238SMExcel Leasing LLC · Excelsior, MNN239TCBombo Aviation LLC · Murrysville, PAN23LXSoft Cloud Consulting LLC · North Salt Lake, UTN245DJLtlvsd LLC · Wilmington, DEN247MPRoar Aviation LLC · Bloomington, ILN24KSYampa LLC · Kenner, LAN24PHExcel3 LLC · Carmel, INN253TBlue Link LLC · Bay City, WIN255RC255rc LLC · Atlanta, GAN25PPTsc Aircraft LLC · Saint Louis, MON264VRTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN26TBirmingham Bravo LLC · Birmingham, ALN26XLVal 67vc LLC · Green Cove Springs, FLN278XL560xl LLC · Newark, DEN286VRTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN291DVFall River Aviation LLC · Corvallis, ORN296VRTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN29QAWar Horse Aviation LLC · Whitsett, TXN2KK2872 Holdings LLC · Burleson, TXN300DACrete Carrier Corp · Lincoln, NEN301HCIntermountain Medical Transport LLC · Salt Lake City, UTN301LWings Of Justice LLC · Bozeman, MTN301VRTonglen LLC · Farmingdale, NYN304MRMirric Entertainment LLC · Pittsburgh, PA
Back to Cessna 560XL