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 ('2072702')
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 ('2072702')
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.
N6465ABertonazzi Kevin M · Vineland, NJFirst renewal noticeN6466ARobinson Jerry L · Mc Call, IDN6471AGwinn Anthony N · Melbourne, FLN6473ASkydive Snohomish Inc · Snohomish, WAN6482AMoreman Wiley E · Willcox, AZN6483AKdrcjt Aviation LLC · Orange, MAN6486AErickson Jon W · Union Grove, WIN6487ALucci Giancinto A · Nashville, MIN6493AThornton Anthony D · Mckinney, TXN6494ARoot Jeff G · Pound Ridge, NYN6495AP Ponk Aviation · Camano Island, WAN6499ATreetop Flying Circus LLC · Niceville, FLN6789KDrc Equipment LLC · Caldwell, IDN699XMBas Part Sales LLC · Greeley, CON7113Rotter Shane F · Olympia, WAN724RJRehkopf Ronald O · Texarkana, TXN7251EFord Michael G · Doerun, GAN73182Savannah Airplanes Venture LLC · Myrtle Beach, SCN7403WJohnston Aircraft Leasing LLC · Highland, CAN744WTwin Bridges Aviation LLC · Sheridan, MTN7835MTimpauer Alberto N · Mesa, AZN82NGallant James II · Scottsville, KYN8306SConte Michael R · Collinsville, OKN8328SAhrens Scott W · Castle Rock, CON8455SWhite Noah Jay · Prairie Du Chien, WIN851MDKiko Peter R · Dalton, OHN8562TBacksen Rick L · Clarkston, WAN8575TChristensen Del S Trustee · Friendswood, TXN859JANational Aircraft Leasing · Greenville, DEN85BBennett Dennis Lane Jr · Hastings, MIN874DTN874dt LLC · Canadensis, PAN8814TSchildberg Gregory M · Casey, IAN8834TCzechowicz Nicholas B · Anchorage, AKN8887XEighty Seven X-Ray LLC · Atlanta, GAN8895TTanner Ken M · Chandler, AZN8914XHawkins William A · Euless, TXN8926XNelson Bobby E · Naples, FLN898BPetropulos James J · Juneau, AKN90FGDavies James W · Oostburg, WIN933DDHarris John Alfred · Havana, FLN95PFEhorn William M · Cottonwood, CAN96047Ohio Car Wash Supply LLC · Lancaster, OHN96051Franklin Evelyn Ruth Trustee · Laveen, AZN967DGPersinger Kenneth W · Fairbanks, AKN988PSStartz Paul D · Douglasville, GAN9917BVisscher Ty · Santa Rosa, CA
Back to Cessna 182