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 ('2075816')
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 ('2075816')
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.
N81APBearcat Aero LLC · Cleburne, TXN8206MMaxon William D · Santa Paula, CAN8207MMurphy Robert A · Kent, WAN8217GVne Aviation LLC · Dripping Springs, TXN8217MBas Part Sales LLC · Greeley, CON8223X23xray LLC · Houston, TXN8224MGreene Dennis M · Desert Hot Springs, CAN8228MMurrin John A · Holbrook, MAN8236MCaptain Sky Helicopters LLC · Sahuarita, AZN823SRLandmark Aerial LLC · Metuchen, NJN8243MBundy Holdings LLC · Walnut Grove, MON8245MSea Seven LLC · Weatherford, TXN8249GComerford John D Trustee · Saint Louis, MON824WPPhillips Wayne A Trustee · Cameron Park, CAN8262VBoyd Russell · Boerne, TXN8268MGilbert Brad E · Heron, MTN8269GReuven Moshe · Marlborough, MAN8291MElbs Aviation LLC · Pell City, ALN82CCDenrow Limited Lc · Shawnee, OKN82FBBolea Air Inc · Morgan Hill, CAN82MEHutt George H III · Stratham, NHN82NACoduto Billy Mark · Shelbyville, TNN82TLRegistration Pending · Roscoe, ILRegistration pending, pending cancellationN8300MWiener Ronald K Trustee · Tucson, AZN8304MUecker Richard H · Dania Beach, FLN8306MJohnson Airspray Inc · Argyle, MNN8309MCarlisle C A P Flying Club Inc · Carlisle, PAN8311MHorton James D · Las Vegas, NVN831PZHildebrant Thomas M · Ringling, OKN8320MBoyce Dale M · Southport, NCN8357MPrinceton Soaring Assoc · Princeton, NJN835TAHuber Gary · Bradenton, FLN8363MWeatherford Ranches Support Services LLC · Arlington, ORN8367EGergis Pierre · Brooklyn, NYN8372MCollins Delbert Ray · Talihina, OKN8388MGreater Chattanooga Aviation Club LLC · Chattanooga, TNN838PGHinton Michael B · Hesperia, CAN84099650 Aviation LLC · San Mateo, CAN84239Wells Richard M · Hartford, KYN8428MNervino David J · Hilmar, CAN84372Madflyer55 LLC · Wilmington, DEN84379Knox John B III · Gregory, MIN84466Carrel Micah Dane · Paris, KYN84488Wheeler Michael T · Chicago, ILN84492Robinson William D · Greer, SCN84507Weston Marcia K · Palestine, TXN84508Goodwin Reginald J O · Clancy, MTN8453MWard Charles B · Salcha, AKN8454MSp Leasing LLC · San Jose, CAN84598Salley Jason · Locust Grove, GA
Back to Cessna 182P