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 ('1152740')
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 ('1152740')
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.
N628AKBaron Partners LLC · Bessemer, ALN628MDClarkton Aviation III LLC · Clarkton, MON62BBUp And Down Aviation LLC · Perry, GAN62CVTessos Air Service Inc · Wilmington, DEN62PKRegistration Pending · Lillington, NCRegistration pending, canceledN6311SNoble Lloyd II Trustee · Tulsa, OKN6334SHokuf Erik L · Bemidji, MNN6351XGilles David L · Clifton, TXN63858Skyway Aviation Inc · Jackson, MIN638LDDion Aviation LLC · Key West, FLN638WCBrown Everette · Edenton, NCN640ACPlane Old LLC · Wildwood, MON6458CMb/F Inc · Greensboro, NCN649ECDriggers David M · Tifton, GAN64DWNavation LLC · Lauderhill, FLN64LAHanner Investments LLC · Appling, GAN64LMTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN64VBTamworth Aviation LLC · Allen, TXN6573KGta Air Inc · Addison, TXN658DGSchardt Aaron · Hastings, NEN6593UWedt LLC · Wilmington, DEN660CKPrecision Delta Corp · Ruleville, MSN6617NSeal William T · Eagle, IDN661WLButterbar Leasing LLC · Virginia Beach, VAN6639KXp Skyhawk LLC · San Luis, AZN6649DBas Part Sales LLC · Greeley, CON66518Daly Stephen M · Oakland, FLN6654YLewis Garry L · Livingston, LAN6658SKgb58 Aviation LLC · Gibsonia, PAN66619West Bend Air Inc · West Bend, WIN6661YSchlosser David · Scottsdale, AZN6662NRegistration Pending · Uvalde, TXRegistration pendingN6666XBlack Sheep Aviation LLC · Palm City, FLN6671XDairy Air LLC · Mount Crawford, VAN66805Opa Aviation LLC · Littleton, NCN6681LRotary Industries Inc · Miami, FLN66849Hawk Aircraft Sales And Leasing LLC · Sterling Heights, MIN6684VFba Leasing LLC · Mountain Brk, ALN6686DN6686d LLC · Idaho Springs, CON66878Cool Blue Air LLC · Wilmington, DEN66918Lbc1 LLC · Mount Olive, NCN66AFSalmon Steven B · Liberty, MON670GCFrauenhoff Frank · Manhattan, NVN6725TQuitman LLC · Spartanburg, SCN6726SSchaney Michael W · Brookville, OHN6728LHancock Aircraft Sales LLC · Baton Rouge, LAN67290Price Edward Rollins Vii · Elon, NCN6729ZMiddle Tennessee Aircraft Services LLC · Mount Pleasant, TNN6734XGood Deal Charlie Inc · Russellville, ARN67352Ascension Aviation LLC · Gaylord, MI
Back to Beech 58