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 ('2072418')
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 ('2072418')
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.
N9605QBragan Ryan J · Dunedin, FLN9607HTwin Oaks Airpark Inc · Hillsboro, ORFirst renewal noticeN9608HCag Aircraft Holdings LLC · Crystal River, FLN9608QLahmers Melvin E · Newcomerstown, OHN9609QWestrup Gregory W · Greensburg, INN960FSSouthern Aero LLC · Homestead, FLN9610QUS Aviation Group LLC · Denton, TXN9612HRegistration Pending · Ocean Isle Beach, NCRegistration pendingN9613HFiedler Mark · Wichita, KSN9614HC&H Elite Air LLC · Johnstown, CON9614QConrad Terry E · Lancaster, OHN9616QClearview Flying Club Inc · Westminster, MDN9617HShinn Lake D · Stevensville, MTN9617QKagin Corp · Wilmington, DEN9621VHathor Aviation LLC · Johnstown, CON9622HSanders Flight Training Center LLC · Jasper, ALN9622QWingsleasing LLC · Wichita, KSN9623VSchreder Peter T · Joseph, ORN9625QMars Aerospace Inc · Bay Shore, NYN9625VFlight Time Builders Inc · Memphis, TNN9626HRenfro Jacqueline L · Bethel, AKN9626QChambers Matthew A · Tehachapi, CAN9627HSuperbuyer Inc · San Jose, CAN9628HT3 Aerosports LLC · Vian, OKN9630QKelley Aircraft LLC · Weyers Cave, VAN9630VN275508 LLC · Margate, FLN9631QHuntsman Ferral Don · Juneau, AKN9631VHarrold Bruce E · Greybull, WYN9632HSweitz-Air Inc · Stewartstown, PAN9633HWings Over Texas Holdings LLC · Denton, TXN9634QDubois County Flight Services Inc · Huntingburg, INN9635HArizona Aircraft Leasing LLC · Mesa, AZN9635QRozynski Jason K · Malabar, FLN9635V35 Victor LLC · Decatur, GAN9636HMontanez Orlando · Guaynabo, PRN9636VNaperville Flying Club · Woodridge, ILN9637QWingsleasing LLC · Wichita, KSN9638HHatbright Farm LLC · Wilmington, DEN9638QPeterson John E · Benton, KSN9638VCrazy Aces LLC · St George, UTN963KMMiller Karl E Trustee · Chandler, AZN9640HCorriher Mark B · Mocksville, NCN9640VN9640v LLC · Ann Arbor, MIN9641HBarton Alva L · Hollister, CAN9641QBhairavi Aviation LLC · Santa Clarita, CAN9641VRink Douglas B · Woolwich, MEN9643HMor Aviation N9643h LLC · Gaithersburg, MDN9643QLeading Edge Flight Academy LLC · Bend, ORN9643VBrazos Valley Flight Services LLC · College Station, TXN9644QSkyhawks Inc · Chippewa Falls, WI
Back to Cessna 172M