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 ('2071816')
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 ('2071816')
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.
N3397JZwerko Sherri · South Plainfield, NJN33DPB&C Cejka Real Estate LLC · Sioux City, IAN3405JRichmond Consulting LLC · Blanding, UTN3406JScholle Joseph E · Mustang, OKN3409JMountain Home Oasis LLC · Albuquerque, NMN3410JNewsom Rickey D · Springfield, ARN3421JOakley Lance · Haslet, TXN3422JRoberts Stephen L · Belmont, MIN3424JBaird Gary H · Bracey, VAN3425JSanders Robert · Harlingen, TXN3429JBrown Jason · Wonder Lake, ILN3433JJason Webster · Orlando, FLN3435JRegistration Pending · Florence, AZRegistration pendingN3440JNoguess Michele R · Deming, NMN3453JBmsf Co LLC · Copalis Beach, WAN3454JIslanders Flying Club · Charleston, WVN3458JHoughton Raymond A · Fort Bragg, CAN345EEKielich Darryl C · Elk Grove, CAN3461JSmith Stephen T · Hale, MIN3466JSale Reported · Fruita, COSale reportedN3467JKlempel Reuel D · Eltopia, WAN3468JC&C Aero LLC · Billings, MTN346BJDixon Craig S · Rimrock, AZN3470JEdson Vincent · Auburn, CAN3471JLogtime Flight LLC · Lancaster, TXN3476JJr Imaging Logistics Inc · Pasco, WAN3482JShelton David R · Potter Valley, CAN3491JNightknight LLC · Palm Bay, FLN3495JWatson John T Jr · Fairfield, CAN3498JThompson Rick L · Chico, CAN358KSForgues Inc · Wilmington, DEN3604JSmtm Holdings Inc · Wilmington, DEN3605JBon Investment Holdings LLC · Zephyrhills, FLN3606JElite Fleet Jacksonville LLC · Jacksonville, FLN3607JSmith Zachary L · Piedmont, SCN3608JSwartzentruber Thomas L · Oakland, MDN3611JShannon James P · Vandergrift, PAN3613JBatista Brasil Vagner · Orlando, FLN3614JSikveland Beau D · Circle, MTN3616JB&R Aircraft LLC · Wadsworth, OHN3617JShowalter Steven L · Goshen, INN3618JWright David G · Lake Oswego, ORN3620JBerens Eric A · Stevens Point, WIN3621JLow Cost Flying LLC · Chandler, AZN3626JEa Cvg LLC · Erlanger, KYN3628JLucarelli David L · Moncks Corner, SCN3632JMitterling Richard H · Boothbay Harbor, MEN3633JMicrokit Solutions LLC · Bridgeview, ILN3634JLuft Inc · North Fort Myers, FLN3638JEngelskirger Karl D · Valley City, OH
Back to Cessna 150G