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 ('2076810', '2076809')
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 ('2076810', '2076809')
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.
N750VPAirelva LLC · Rocklin, CAN750XCTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN750XXAlliance 171 LLC · Valencia, CAN751AANitajet X LLC · Great Falls, VAN751EMGlobal Automation Solutions Inc · Marlborough, CTN751GTCx58 LLC · Fort Lauderdale, FLN751MMMorgans Mach One Machine LLC · Aspen, COFirst renewal noticeN751XJBank Of Utah Trustee · Salt Lake City, UTN752GTGta56 LLC · Fort Lauderdale, FLN752RJHutchins Jet Company LLC · North, SCN752WJCx 34 LLC · Southwest Ranches, FLN753XJMach .92 Leasing LLC · Raleigh, NCN75HSPerfect X Aviation LLC · Frisco, TXN75TXTextron Inc · Providence, RIN760XJMach .92 Leasing LLC · Morehead City, NCN764XJMach .92 Leasing LLC · Raleigh, NCN765XJMach .92 Leasing LLC · Raleigh, NCN767XJDodson International Parts Inc · Rantoul, KSN769XJN560mc LLC · Raleigh, NCN770CJN770cj LLC · Williamsburg, VAN770XJCottonwood Holdings LLC · Buckner, KYN772XJMach .92 Leasing LLC · Raleigh, NCN774XJMach .92 Leasing LLC · Raleigh, NCN777KTFpv LLC · Dover, DEN778XJTen Two LLC · Carmel, INN780XJMach .92 Leasing LLC · Morehead City, NCN782XJMach .92 Leasing LLC · Morehead City, NCN783MCN560mc LLC · Raleigh, NCN784XJJvd Aviation LLC · Morehead City, NCN786XJWilmington Trust Co Trustee · Wilmington, DEN787MGMakgab Holdings LLC · Pompano Beach, FLN787THFly The Coop Aviation LLC · Willow Park, TXN789XJCitation N789xj LLC · Waukesha, WIN78ZEStaff-Up LLC · Dallas, TXN790XJMach .92 Leasing LLC · Morehead City, NCN792XJSn 53 LLC · Doral, FLN793XJB And F Rentals LLC · Cary, NCN794XJMach .92 Leasing LLC · Raleigh, NCN795HGTour Air LLC · Ponte Vedra Beach, FLN797CXFmat Inc · Alta Loma, CAN79ZETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN7SBHp Aviation Services LLC · Winter Garden, FLN800CGDartswift Inc · Philadelphia, PAN808GGNd Aviation LLC · Kansas City, MON815RBBchjet1 LLC · Wilmette, ILN817RAMayfair Aviation LLC · Benbrook, TXN818CFCitation X Leasing LLC · Liberty, NCN845FPFmp Aviation LLC · Eagan, MNN858THTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN85AVSale Reported · Montgomery, ALSale reported, pending cancellation
Back to Cessna 750