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 ('2071818')
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 ('2071818')
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.
N6572SGlatt Nicolas · Mazama, WAN6586SMiller William H · Live Oak, FLN6589SAdamson Paul B · Sparks, NVN6590SCoonley Russell F · Decatur, TXN6592SBasista Robert J · Delaware, OHN6593SMilam David N · Hannibal, MON6595SGlobal Flight Training Solutions Inc · Immokalee, FLN6603SColonial Air Inc · New Bedford, MAN6615SStott Thomas W · Fort Shaw, MTN6617SKembel Robert D · Saint Ignatius, MTN6618SLipski Robert · Wallingford, CTN6619SFun Flight Training LLC · Bartow, FLN661DDHanisko Thomas F · Mount Shasta, CAN6620SFellegy James M · Mauston, WIN6623SWilliams Nathan · Von Ormy, TXN6626SFast Aircraft Aerowork Corp · Miami, FLN6628SN6628s LLC · Arlington, TXN6630SRoss Air Chicago LLC · Chicago, ILN6633SRegistered aircraftN6635SCoughanowr David D · Chatham, MAN6639SMoen Richard C · West Dundee, ILN6642SSellers Douglas D · Webster, NYN6654SNick Franke LLC · Jacksonville, ARN6661SHayton James B · Sedro Woolley, WAN6672SPikul Daniel J · Monson, MAN6679SCampos Katherine · Tallahassee, FLN6683SWingsofdawn LLC · East Greenwich, RIN6687SSale Reported · Houston, AKSale reportedN6689SSimpson Dwight D · Phillips, WIN6690SSeniram Air Inc · Wilmington, DEN6692SNoltensmeyer Kurt Jon · Greenbank, WAN6695SOlsen Raymond E · Washington, UTN6696SJohnson Jay E · Murray, IAN669JKGeddes Michael · Seattle, WAN6700SAgape Enterprises · Montana City, MTN6701SKnipping Richard W Jr · Winterport, MEFirst renewal noticeN6705SMiszczak Ethan · Newnan, GAN6706SDavis Bradley · Oconomowoc, WIN6712SDunaire LLC · Mechanicsburg, PAN6718SRoberts Brandon R · Bogata, TXN6720SWilliams Kenneth J · Hampton, NYN6721SRenwick Stephen P · Moss Beach, CAN6722SCampbell J Tyler · Chestertown, MDN6725SMarshall Jerry J · Parker, AZN6728SStevens Matthew S · Penn Yan, NYN6729SCain Tyler M · Houston, TXN6731SHaug Jeffrey S Trustee · Leawood, KSN6744SGoodrich Flying LLC · Corinne, UTN6755SLewis Reylenard A · Federal Way, WAN6756SEnstrom Thomas J · New Berlin, NY
Back to Cessna 150H