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.
N860TXCitation X Leasing LLC · Liberty, NCN864MMM+M X LLC · Kansas City, MON868DMP&G Aviation LLC · Wilmington, DEN882KBF Korbel & Brothers Inc · Guerneville, CAN886EPSpfm Lp · San Antonio, TXN888TXChoctaw Aviation LLC · Addison, TXN89BCGeorgetown Aviation LLC · Englewood, CON8JCBank Of Utah Trustee · Salt Lake City, UTN900KMWahoo Enterprises LLC · Houston, TXN900UPRyan Air LLC · New York, NYN901TXRegistered aircraftN901UPRyan Air LLC · New York, NYN902PGP&G Aviation LLC · Wilmington, DEN902UPRyan Air LLC · New York, NYN903TATeam Aero LLC · Olathe, KSN903UPRyan Air LLC · New York, NYN904TXRyan Air LLC · New York, NYN904UPRyan Air LLC · New York, NYN905UPRyan Air LLC · New York, NYN905VRN954dj LLC · Fort Lauderdale, FLN906TXRyan Air LLC · New York, NYN907TXRyan Air LLC · New York, NYN908UPRyan Air LLC · New York, NYN909UPRyan Air LLC · New York, NYN910DPN910dp LLC · Bethlehem, PAN910ECitation X Leasing LLC · Liberty, NCN910VPYc Equipment Co LLC · Orangeburg, SCN917PGAir Play I LLC · Dover, DEN918TXRyan Air LLC · New York, NYN920TXRyan Air LLC · New York, NYN926VRCitation X Parts LLC · Liberty, NCN92MKBank Of Utah Trustee · Salt Lake City, UTN92RXSideline Inc · Tuscaloosa, ALN92THGoshawk Consulting LLC · Belgrade, MTN939TXCitation X Parts LLC · Liberty, NCN93STen Three LLC · Carmel, INN943ELRyan Air LLC · New York, NYN945JSBluyonder Aviation LLC · Dover, DEN946TXB And F Rentals LLC · Cary, NCN947ELCx Echo Lima LLC · Addison, TXN947JSDg Leasing LLC · Houston, TXN948TXAir Play II LLC · Dover, DEN953TJComrie Jet X LLC · Cape Coral, FLN954JSCitation X Parts LLC · Liberty, NCN954MFWabash IV Aviation LLC · Fort Lauderdale, FLN955GHCitation X Leasing LLC · Liberty, NCN957JSCitation X Parts LLC · Liberty, NCN957TXRyan Air LLC · New York, NYN95DFPrairieland Farms · Divernon, ILN962TXAlliance Air Parts Acquisitions Corp · Oklahoma City, OKNon-citizen corporation, flight hours not reported
Back to Cessna 750