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 ('2072418')
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 ('2072418')
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.
N868SAS O W Aviation LLC · Crystal River, FLN86VBAce Flight Center · St Thomas, VIN870TWSouthern Haulers LLC · Leachville, ARN875CDBoca Pilot LLC · Delray Beach, FLN880CBJ-Airco LLC · Nashville, TNN8881VLien Ronald N · Gilford, NHN8882VTop Aircraft Leasing LLC · Wilmington, DEN8889VGarcia Hector A · Caguas, PRN888CBBenz James E · Pittsford, NYN888CMKelley Aircraft LLC · Weyers Cave, VAN888TACurrier Winston F · Monroe, NHN8890VBig Q Aviation · Helena, MTN8891VPropel Air LLC · Pottstown, PAN8892VBillingsley Carl R · Henderson, TXN8893VEast Tennessee Pilots Club · Knoxville, TNN8894VBeckworth Brad T · Jacksonville, FLN88ABBrown James L · Athens, ALN88EStarlite Aviation Technologies LLC · Las Vegas, NVN8902VFlycarolina LLC · Concord, NCN8904VWaymaker Aviation LLC · Yukon, OKN8906VLewis David A · Broadalbin, NYN8911VHorizon Dreams LLC · Homer, GAN8912VRoper Jeff A · Corralitos, CAN8913VI'Ll Fly Away LLC · Florence, SCN8916VTaylor William W Jr · Hudson Oaks, TXN8919VChristiansen John · Vicksburg, MIN8921VN2827n LLC · Pembroke Pines, FLN8922VTampa Bay Aviation Inc · Clearwater, FLN8924VDupree Johnny · Crossett, ARN8926VCareer Flight Training And Aircraft Rental LLC · Naples, FLN8927VTropical Aviation LLC · Gulf Shores, ALN8931VAeroventures 8 LLC · Mt Carmel, TNN8932VEverett William M · Tuscumbia, ALN8934VUniversal Aviators Academy Inc · El Monte, CAN8937VCowden Steven B · Bellingham, WAN8941VSky Castle Aviation LLC · New Castle, INN8942VPilots Flying School LLC · Englishtown, NJN8943VZiegler Aviation LLC · Minneapolis, MNN8946VWings Over Texas Holdings LLC · Denton, TXN8947VMills Alan F · Chatom, ALN8948VPlain Company Ltd · Bloomfield Hills, MIN8957VN8957v LLC · Fort Lauderdale, FLN8958VHyldburg Aviation Inc · Plymouth, MAN8961VHampton Flying Services LLC · Portsmouth, NHN8961ZHein-Reece Linda K · Shelton, WAN8964VOneill Jared · Gilroy, CAN8966VCreider Paul E · Tulsa, OKN8968VLittle Gordon D · Watertown, SDN8969VCrowley Brett A · Wasilla, AKN8970VWinding Creek Aviation LLC · Snellville, GA
Back to Cessna 172M