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 ('2072704')
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 ('2072704')
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.
N282CPWright Andrew T · Clyde, OHN314SOrem John Marshall · Shallowater, TXN330FSkydive Wayland LLC · Melbourne, FLN333VWHelderman Laban W · Newton, NCN3661TOmega 1 Corp · Middletown, DEN366KWhite Thomas J · Agua Dulce, CAN3707DWilliams Charles S · Pearland, TXN3709DAbidance Inc · Winthrop, WAN3710DHiller Paul D · Grafton, OHN3713DHedgecock David H · Elkhorn, WIFirst renewal noticeN3714DZombo Brian T · Youngsville, NYN3719DVector Stunts Inc · Bend, ORN3720DHarrington Patrick M · Quitman, MSN3722DSkydive Inc · Eagle Creek, ORN3723DOlsen'S Grain Inc · Chino Valley, AZN3725DMulhaney James T · Wasilla, AKN3727DTwo Seven Delta LLC · Meridian, IDN3728DRoberts Anthony E · Millville, CAN3730DLedbetter Jeffrey Allen · Huntley, ILN3732DClark William M · Ann Arbor, MIN3734DVessey William M · Yuma, AZN3738DHall Chris S · Garden City, MON3739DBodie Aviation Ltd · Laporte, CON3741DTrouwborst Keith J · Lander, WYN3743DLanzisera Francesco · Questa, NMN3744DMorcom Ronald W Jr · Stanwood, WAN3748DPetersen Jacob R · Wasilla, AKN3754DEckard Eric M Trustee · Wasilla, AKN3756DAnderson Daren J · Almond, WIN3756UKlinger Cattle Co Inc · Friona, TXN3758DStrother John G · Kenai, AKN3762DSteves Aircraft · Lakeport, CAN3766DFree Range LLC · Missoula, MTN3768D3di LLC · Elizabeth, WVN3774DVandal Air LLC · Boise, IDN3775DRegistration Pending · Churchville, MDRegistration pendingN3777DOrchid Aero LLC · Lakewood, CON3778DBrownd Carl L · Oro Valley, AZN3779DSeattle Glider Council Inc · Bellevue, WAN3781DHelmer Douglas A · Avon, INN3785DKing John H · Trumansburg, NYN3789DBeasley Charles J · Batesville, ARN3791DRoberts James O · Billings, MTN3794DDelahousie David L · Apple Valley, CAFirst renewal noticeN3796DHowerton Pamela S · Bartlesville, OKN3797DGeorge Daniel K · West Union, SCN3800DParker Bruce C · Boise, IDN3802DCorbitt Mindy J · Ocoee, FLN3803DSaunders Clinton E · Belgrade, MTN3804DGabbert Lucious L · Prescott, AZ
Back to Cessna 182A