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 ('2072439', '2072442')
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 ('2072439', '2072442')
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.
N6042ZL&G Skycatcher LLC · Bradenton, FLN6048ZRegistration Pending · Wilmington, DERegistration pendingN604NDHeavy Metal Air LLC · Farmingdale, NYN604TTUniversity Of Alaska Anchorage · Anchorage, AKN6051VBucelluni Brett · Cypress, TXN6059DLong Island Aviators LLC · Seaford, NYN6059RGlidewell Aviation Inc · Parkland, FLN605MAAir Assets LLC · Orlando, FLN60603Christiansen Aviation LLC · Wilmington, DEN60616Mustang Sally Aviation LLC · Camden, SCN6064RSvetfur Aviation LLC · Camden, SCN6065LAvolant Aviation LLC · Mooresville, NCN6065MPhoenix East Aviation LLC · Daytona Beach, FLN6065PS R Liner LLC · Canton, MAN606LFLunken Flight Training Center LLC · Cincinnati, OHN606NDDavidson Flight Service LLC · Gig Harbor, WAN6074FFly America Inc · Palo Alto, CAN6097GSargester Aviation LLC · Middletown, DEN610SPPocket Rocket LLC · San Francisco, CAN611EKWings Over Texas Holdings LLC · Denton, TXN61237Phoenix East Aviation LLC · Daytona Beach, FLN6137QJeffery & Weiss Holdings LLC · Long Beach, CAN613LGRidgeline Assets LLC · Wilmington, DEN613SPAirmart Inc · Lexington, KYN614FAHillsboro Aero Academy LLC · Hillsboro, ORN6152HMarcair Inc · Fort Worth, TXN615SPChesapeake Skyhawks Inc · Wilmington, DEN617SPPrecision Design Inc · Wilmington, DEN61808Cape Island Aviation LLC · Millville, NJN6180WChristiansen Aviation LLC · Wilmington, DEN6180XLewis University · Romeoville, ILN6185UMustang Sally Aviation LLC · Camden, SCN6186TAtlas Aviation Tampa Inc · Tampa, FLN6186VFloriflt LLC · Daytona Beach, FLN6189QParamus Flying Club Inc · Fairfield, NJN618DHCorsair Aviation LLC · Pacoima, CAN618JMSkyknight LLC · Greeneville, TNN618VCRaevin Aviation LLC · Bellmore, NYN6190CChristiansen Aviation LLC · Wilmington, DEN61942Middle Village Enterprises LLC · Maspeth, NYN6194VChristiansen Aviation LLC · Wilmington, DEN6196PChristiansen Aviation LLC · Wilmington, DEN6198NChristiansen Aviation LLC · Wilmington, DEN619CTCoast Flight Training And Management Inc · San Diego, CAN619SPJet Air Inc · Iowa City, IAN619THAce Aviators LLC · Logan, UTN61WTMonmouth Area Flying Club Inc · Lakewood, NJN6208CMustang Sally Aviation LLC · Camden, SCN620JASilverhawk Aviation Academy LLC · Caldwell, IDN620SPGulf Coast Aviation LLC · New Orleans, LA
Back to Cessna 172S