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 ('2072703', '2072707', '2072705')
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 ('2072703', '2072707', '2072705')
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.
N631CPCivil Air Patrol · Maxwell Afb, ALN63275Qualitair LLC Trustee · MichelstadtN632CPCivil Air Patrol · Maxwell Afb, ALN632ESArvidson Randall C · Brighton, MIN632MRNational Aircraft Leasing Corp · Greenville, DEN632TKKentucky State Police · Frankfort, KYN6330DReliant Technologies Incorp · Port Allen, LAN6334WColwell Kevin · Middleton, WIN6335ZLs Express LLC · Syosset, NYN6337KK-Ville Flyers LLC · Newmanstown, PAN633CPCivil Air Patrol · Maxwell Afb, ALN6345DRumble Aviation LLC · Thomasville, GAN63461Georgia Golf Cars Inc · Douglas, GAN6346ERudd Richard L · Cornelius, NCN6348AGzs Aviation LLC · Dover, DEN634CPCivil Air Patrol · Maxwell Afb, ALN6353MMont Belvieu Materials Inc · Mont Belvieu, TXN635CPCivil Air Patrol · Maxwell Afb, ALN636CPCivil Air Patrol · Maxwell Afb, ALN6372BCm Air LLC · Wilmington, DEN637CPCivil Air Patrol · Maxwell Afb, ALN637RMOtn Skylane LLC · The Woodlands, TXN6383CBurton Brandon · Canton, GAN638CPCivil Air Patrol · Maxwell Afb, ALN63921Nc Division Of Marine Fisheries · Morehead City, NCN639CPCivil Air Patrol · Maxwell Afb, ALN640CPCivil Air Patrol · Maxwell Afb, ALN643PEColiseum Aviation LLC · Little Rock, ARN644CPCivil Air Patrol · Maxwell Afb, ALN6492GState Of North Carolina · Raleigh, NCN649CPCivil Air Patrol · Maxwell Afb, ALN652171434 Jpl LLC · Wilmington, DEN65225Leon Manuel Perez · Lake Worth, FLN65236Taylor Jonathan P · Danbury, CTN65279Ferrara Joseph Vincent · Port Saint Lucie, FLN65306Bullet Power Brokers Inc · Stuart, FLN65324Bickerstaff Mike · Port Orange, FLN65328Lingyun LLC · Winter Garden, FLN65358Peanut Productions LLC · Sheridan, WYN65367Wheels Up Re LLC · Odenville, ALN6538WVenture Flying LLC · Mobile, ALN65413John Mccaskill Enterprises LLC · Tifton, GAN65472Registered aircraftN65504Bg Ip LLC · Saratoga, CAN65507Cora & Associates LLC · Norcross, GAN65512Wiebe Van Michael · Filer, IDN65514Vogt Gregory A · Broken Arrow, OKN65557Classic Aircraft LLC · South Bend, INN65567Skylane Sky LLC · North Palm Beach, FLN6558EZata Group LLC · North Little Rock, AR
Back to Cessna 182T