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 ('2072732')
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 ('2072732')
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.
N803MWMowotech Inc · Boca Raton, FLN811LLLa Vida Aviation LLC · Lake Bluff, ILN812KRSchneider Richard A · Ellicott City, MDN819DGPadrew LLC · Fort Lauderdale, FLN820CRCeal Company LLC · Long Beach, CAN821HGGeorgia Aviation Authority · Eastman, GAN824BABarr Air Patrol LLC · Mesquite, TXN828LFFinseth Loren V Trustee · Fountain, MNN828PBAero Missions LLC · Zeeland, MIN828RHMad Kav Properties LLC · Corona, CAN82DZJosephine Air LLC · Castle Rock, WAN82KYKentucky Department Of Aviation · Frankfort, KYN82WAVomela Paul Trustee · Wasilla, AKN82XTPerreault Mark L · Van Buren, MEN831DTR & R Plane LLC · Lewiston, IDN831LLState Of Illinois · Springfield, ILN837GACampbell Stephen V · Farmingdale, NYN847JFKartel Douglas S · Boise, IDFirst renewal noticeN84LMSchaefer Bernard C · Fairfield, TXN85RN85 Romeo Group Lp · Wildwood, MON86DDJasair LLC · Scottsdale, AZN86DTEby Cattle LLC · Tonto Basin, AZN86MRThompson Charles E II · Elizabeth City, NCN876SMNathan Smith Ministries · Belmont, NCN882QHowell Andrew · Pinedale, WYN883DDKelly David C II · Roseville, CAN887CMHigh Top LLC · Leclaire, IAN8881NHero Enterprises LLC · Panama City Beach, FLN8883XMyrtle Aviation Inc · Wichita, KSN888GTOptic Air LLC · Maurice, IAN88JDRichardson H L · Reform, ALN88MLProstar Flight Services LLC · Bozeman, MTN8CRJ And J Shop Heliair LLC · Laurel, DEN900RPCobra Aviation Services LLC · San Angelo, TXN9031UBlue Sky Aero Club Inc · Escondido, CAN907ATAirglas Inc · Achorage, AKN913NTCorrao David A · Reno, NVN915CHLegacy Aire LLC · Kennesaw, GAN91AZGulf Coast Helicopters Inc · Pearland, TXN91CCDeep Creek Aviation LLC · Ashburn, GAN91DAJav Air Services LLC · Anchorage, AKN920NWDavis Theodore T · Lake Oswego, ORN922DBWaldron Stephen W · Murfreesboro, TNN925ABJavelina Trax LLC · Saint Charles, MON928JCLatimer Nelson R · Oxnard, CAN9291Henderson Charles B · Houston, TXN929PMRegistered aircraftN9317Avignati West LLC · Santa Barbara, CAN93FMAms Aviation LLC · South Bend, INN93MBNorthwoods Air LLC · Orono, ME
Back to Cessna 182Q