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 ('2073709', '2073710')
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 ('2073709', '2073710')
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.
N45086Dahl Ken L · Granite Falls, MNN45128Bowker James K · Ponca City, OKN45188Arias Armando D · Santa Cruz, CAN45193Bostwick James · Melrose, NMN45248Lewis Steven A · Mesa, AZN45250Thiele Klaus U · San Diego, CAN45277Fritz Kurt C · Montoursville, PAN45312Heap Agriculture Service LLC · Stronghurst, ILN45336Kelley Joshua S · Anchorage, AKN45349Wall Johan D · Brookston, TXN45359Clapp Edwin G III · Fargo, NDN45367Christensen Robert T · Presho, SDN45385Steklenski Philip G · Olympia, WAN45677Davidson Christopher Scott · Friant, CAN45835Yoakam John A · North Ridgeville, OHN45WSRandazzo Meredith · Matthews, NCN478TSTc Aero Services Inc · Wilmington, DEN47BJMisunas Mark · Daytona Beach, FLN47RHWilson Alexander M · Inyokern, CAN4EXBurgess Kevin R · New Bedford, MAN4NVEndter Vincent · Gilroy, CAN50016Cotner Jeff T · Bonham, TXN502WACommodore Jr Paul S · Tinton Falls, NJN50457Odyssey Entertainment Inc · Crystal, MNN50770Schlegel Mark W · Waterford, MIN50961Flight Skills LLC · Raleigh, NCN51300Loftin Gabe · Weatherford, TXN51386Russell Joseph M J · Douglas, WYN516APStewart Stewart D · South Egremont, MAN520Registered aircraftN52015Gibbs Timothy L · Valley Grande, ALN52017Worringer Richard G · Tower, MNN52019Bryant Robert D · Perry, UTN52044Peck John E · Everett, WAN52046C10 Fire Aircraft Holding LLC · Sunriver, ORN52050Brown Thomas A · Lake Stevens, WAN52061Ortego Kenton M · Lake Charles, LAN52074Harris Nancy B · Christiansburg, VAN52076Macair Aviation LLC · Xenia, OHN52087Bodkin Donna E · Patchogue Village, NYN52093Helgeson Jeffrey D · Colonia, NJFirst renewal noticeN52101Defontes Kenneth W Jr · Kingsville, MDN52120Compass Aviation Maintenance LLC · Shelby, NCN52132Registered aircraftN52152Schmidt Michael D · Windermere, FLN52154Fairfax Stephen A · Johnson City, TXN52156Rbl Missions LLC · Newcastle, CAN52167Vajtay Catherine · Englewood Cliffs, NJN52177Lundahl Frederick · Langley, WAN52190Vass Gal Alex D · Merrimack, NH
Back to Cessna 177RG