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 ('1220460')
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 ('1220460')
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.
N2725ZGeorge Ladelle L · Ashley, NDN2735ZSoucy Gary J · Brewer, MEN2737ZBrown Joseph Earl · Lawrenceburg, INN2819ZHogan Thomas A · Fairfield, OHN2868ZWanda Collins Professional Pilot Services LLC · Madisonville, TXN287EBBoorom Mikel E · Jackson, MIN2884ZSpurgeon Paul M · Brooksville, MSN2888ZHonkomp Daniel · Euless, TXN2895ZRao Enterprises LLC · Brighton, MIN2923ZAnkole Watusi Cattle Company LLC · Leesburg, FLN2956ZAm Flite Inc · Valley, NEN2974XAnderson Keith · Covington, TNN2979PRussman Nicholas S · Farmersville, TXN29900Parsons Dennard C · Mount Dora, FLN2996ZKerr Ian A · Redwood City, CAN2EZScott Flying Service Inc · Bono, ARN31259Rowlett Jeffery B · Tuckerman, ARN31267Kieffaber Thomas M · Sagamore Hills, OHN31269Happenstance LLC · Cabot, ARN31281Citabria 1972 LLC · Soldotna, AKN31298Rivers Jerry M · Chesterfield, SCN313CEAvidash LLC · Cape Coral, FLN3233TByrne Gary W DBA · Georgetown, INN337CBErickson Arnold F · Devils Tower, WYN36009Svanda Roger D · Tyndall, SDN36140Phillips James M · Wilmington, NCN36174Meise Fred W · Moses Lake, WAN36285Schreiber Ray R · New Palestine, INN36336Mierzejewski Karl · State College, PAN36349Richardson Thomas R · Valleyford, WAN36353Mcbride Mark · Sutton, MAN36412Martinsen John James · Aberdeen, WAN372FTTownsend Frederick H · Ortonville, MIN4110YHeiderscheidt Cory · Sleepy Eye, MNN4121YStotts Jimmy W · Jonesboro, ARN4139YPremier Management Co Inc · Mobridge, SDN4140YBuckman Dean D · Monroe City, MON4141YWells Kevin R · Elko, NVN4151YWarner Kenneth G · Granbury, TXN4157YMclean Garrett Thomas · Soldotna, AKN41683Ferraro Jeffrey T · Mckinney, TXN41688Breunig Gerald S · Newark, ILN4168YThree Point LLC · Lacon, ILN41693Glasford John T · Rapid City, SDN41698Collier James R · Castle Rock, CON4172YColonels Flying Club · Princeton, MNN41800Mccully Heather L · Payson, AZN41805Fosdick Kenneth E · Plymouth, MAN4181YBruce A Morey · Wills Point, TXN41820Wagner Patricia · West Milton, OH
Back to Bellanca 7ECA