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 ('2072708')
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 ('2072708')
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.
N8734TSkimt Aviation LLC · Teaneck, NJN8737TSchmitt Gary W · Highlands, NCN8739TScranton Brian J · Ridgway, CON8741TTolman Jeremy Charles · Mcalester, OKN8744TEdhlund Joseph W · Brush Prairie, WAN8748TDennis Richard E · Gakona, AKN8752TTortorige Carl J · Quincy, ILN8753TZaccheo Vincent S · Ulster Park, NYN8754TBurrington Steven A · Austin, TXN8759TBlack Clifton D · Newnan, GAN8760TMccandless Aviation LLC · Omaha, NEN8761TProsystems Consulting LLC · Saguache, CON8762TCrook Brady G · Bandon, ORN8767TReppond Richard · Sage, ARN8768TCarter Douglas A · Tower, MNN8769TCopper River Airmotive LLC · Copper Center, AKN8770TNoble Aviators Inc · Kendallville, INN8778TLogan Ronald Thomas Jr · Newfoundland, PAN8779TSkyair Express LLC · Overton, NVN8781TFereday Richard R · Mccall, IDN8782TGood Altitudes Aviation LLC · Spring Hill, KSN8790TGray Teddy G · Scarbro, WVN8791TStoesz Chad G · Hailey, IDN8792TFanning Fred W · Fairlawn, OHN8793TWilkinson Daniel · Brownwood, TXN8794TWilcox Rhonda R · Boulder, CON8799TPatterson Danny DBA · Levelland, TXN8800TWormley Steven D · South Beach, ORN8803TGoetze Frank W · Sewickley, PAN8805TMoore Chase M · Billings, MTN8808TGreissing John P · Aguila, AZN8813TBruno Samuel P · Missoula, MTN8815TWills Casey B · Gulf Shores, ALN8817TTop Hand Inc · Laurel, MTN8822TMorris Joshua · Bayfield, CON8823TSoaring Club Of Houston Inc · Waller, TXN8824TKotek Nicholas · Meridian, IDN8826TShapiro Irwin H · Aventura, FLN8830THotrod Aviation LLC · Springdale, ARN8831TPacific North Hunters LLC · Kodiak, AKN8832TDickson Charles F · Ponte Vedra Beach, FLN8837TSimon Jevon D · Buckley, WAN8839TKansas Farm And Ranch Inc · Seneca, KSN8840TNelson William J · Hamilton, MTN8842TMcnamee Michael P · Anthony, NMN8843TDiscovery Medical Research LLC · Kearney, NEN8845THeaton James D · Cuba, MON8846TN8846t LLC · Canyon, TXN8848THawkins Donald M · Borrego Springs, CAN8850TAmalong Timothy M · Tucson, AZ
Back to Cessna 182C