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 ('2072738', '2072739')
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 ('2072738', '2072739')
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.
N123GHMoyers Jeff · Troy, VAN123JSBlue Sky Ventures LLC · Bridgeport, CTN1243NZenisek Andrew F · Sioux Falls, SDN1247VSchwartz Mark S · Woodbury, NYN124KYMozzie Air LLC · Tampa, FLN125AHPray Ricky Lee Trustee · Woodland Hills, UTN125AKBaize Equipment LLC · Crawford, TXN126KMVan Bortel Aircraft Inc · Arlington, TXN1274VDiamond Specialized Inc · Richmond, OHN1315BN1315b Aviation LLC · Wilmington, DEN131DLEscondido Aviation LLC · Marfa, TXN1322YAlcyone Trust Corp Trustee · Wichita, KSN1323NJohnston Jeffrey Heath · Midland, TXN13259Nuthatch Air Services LLC · New York, NYN1325DMontero Carlos · San Lorenzo, CAN1325YDuty First Holdings LLC · Wichita, KSN1328NFirst Agri Inc · Sudan, TXN1329DHewitson Enterprises Inc · Avenal, CAN134GWFord Matthew L · Clayton, GAN134KAHgj Capital Holdings LLC · Newark, DEN135TRTrue Equipment Leasing LLC · Bozeman, MTN1389BColumbia Safety Medical LLC · Kennewick, WAN138AZTablemax Aeronautics LLC · El Paso, TXN1391AAqua Aviation LLC · Danville, CAN140TAGuggenair LLC · Carbondale, CON1421KFjb Flyers LLC · Scottsdale, AZN14221Hilltop Growers LLC · Oceano, CAN1425AVan Bortel Aircraft Inc · Arlington, TXN14306Orkiszewski Jerzy · Scottsdale, AZN1437RMcis Aviation LLC · Wilmington, DEN14510Bates Russell L III · Norman, OKN14513Owens Kevin · Georgetown, TXN1455RFein Eric N · Bernardsville, NJN1456D1456d Nvestments LLC · Lake Havasu City, AZN1462NEuroaviation Inc Trustee · KematenN1465BTomahawk Aero Services LLC · Bellingham, WAN147AJAviation Solutions LLC · Louisville, KYN147CETwin P Aviation LLC · Fort Worth, TXN1483CWang Helin · Dana Point, CAN1485CLiebowitz Alan · Sioux Falls, SDN148GHLattimore Partners LLC · Fort Worth, TXN149ABVarga Miklos · Helendale, CAN149GRJoemchem LLC · Sparta, TNN151PAIntermountain Fabrication LLC · Jerome, IDN153CSSawyer Jonathan · Littleton, CON1543TVan Bortel Aircraft Inc · Arlington, TXN1552SZimmer Eric Fritz · Temecula, CAN156Koche Gary · Downers Grove, ILN1568WDfb Holdings LLC · Coeur D Alene, IDN163AWMccall Andrew Keith · Abilene, TX
Back to Cessna T182T