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 ('2071826')
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 ('2071826')
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.
N6540GKultti Richard O · Sonoma, CAN6545GBoomer Aviation Inc · Fort Walton Beach, FLN6547GLarson Jerry L Jr · Shelby, MTN6548GRoeder Paul A · Waukon, IAN6549GAviaschin LLC · Frisco, TXN6554GAll Bid Inc · Opelousas, LAN6556GBurnett Gregory D · Union, KYN6561GDave Faust Inc · Wellington, KSN6563GVito Air Inc · Wilmington, DEN6565GRoberts Brian L · Shelbyville, INN6566GHopkins Juan A · Nogales, AZN6568GAntler Aviation And Wildlife Service LLC · Wasilla, AKN6572GAero Equities LLC · Ventura, CAN6580GMonskey David Paul · Minnetonka, MNN6581GCox Martin S · Greenwood, INN6583GRusch Steven A · Sequim, WAN6585GPace Glen M · Columbia, MSN6587GGilkes Simon J · Gilbert, AZN6588GAstro Aviation Inc · Whitney Point, NYN6594GKabat Orville · Rudyard, MIN65978Freeland Christopher G · Brownwood, TXN6597GOff Airport Adventures LLC · Saint David, AZN65981Registration Pending · Dubuque, IARegistration pendingN65984Woelbing Aviation LLC · Franksville, WIN65985Moreira Hiosvany · Pensacola, FLN65986Ahern Michael · El Reno, OKN65997Dalton John C · Hernando, MSN66006Registration Pending · Souderton, PARegistration pendingN66009Cowan Ronnie C · Glasgow, KYN6600DMarsh John E · Washington, DCN66017Engelhardt John · Kingwood, TXFirst renewal noticeN6606GRoach Georgia L · Dewitt, ARN6610GThomas Charles L · Yankton, SDN6614GDonaldson Charles R · Marfa, TXN6616GSale Reported · Pineville, LASale reported, pending cancellationN6617GGeneral Aviation Holdings LLC · Port Orange, FLN6618GKonkle Tyrel J · Morristown, TNN6619GKlenptner Lori Jo · Henderson, NVN6620GN6620g LLC · Monticello, INN6622GSky High Adventures LLC · Wilmington, DEN6624YGay Don A · Garfield, GAN6627GBelov Konstantin V · Sierra Madre, CAN6631GRegistration Pending · Oak Creek, WIRegistration pendingN6640GKruckeberg Leroy A · Sanford, NCN6641GWalborn Carl L · Sun City, AZN6642GBurgmeier Peter W · North Vernon, INN6643GStokes Patricia A · Nenana, AKFirst renewal noticeN6644GLive2flyfl Inc · Wilmington, DEN6646GJenkinson Jeffery J · Montgomery, TXN6654GAviation Trust Co LLC Trustee · Oklahoma City, OK
Back to Cessna 150L