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 ('2072434')
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 ('2072434')
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.
N733FRCrotts Aircraft Service Inc · Dodge City, KSN733FSArbach Enterprises Inc · Watertown, SDN733FTRegistration Pending · Blaine, MNRegistration pendingN733FUSimplifly LLC · Mesa, AZN733FXCynthiana Flying Group Corp · Cynthiana, KYN733GBDouble Bridges Aviation LLC · Enterprise, ALN733GCWilliams Steve A · Tamms, ILN733GKHearn Richard J · Gardner, KSN733GLWhitewater Aviation Inc · Harrison, OHN733GMHansen Jens E · Arroyo Grande, CAN733GQMarc Aircraft Holding LLC · Soldotna, AKN733GSWings Over Texas Holdings LLC · Denton, TXN733GTSanchez Demolition Inc · Bosque, NMN733GVRiya Aviation LLC · Tracy, CAN733GXMarianas Air Transfer Inc · Saipan, MPN733GZRichardson Charley Mack II · Mount Pleasant, SCN733HAHuerta Holdings Inc · Santa Ana, CAN733HCWings Flight Enterprises Inc · Danville, KYN733HDFuqua Michael B · Chatham, VAN733HFVr Aerospace LLC · Seattle, WAN733HHThomas Ramone · Philadelphia, PAN733HJRegistration Pending · Bay Harbor Islands, FLRegistration pendingN733HKVan Anda Aviation LLC · Apopka, FLN733HNAriaprima LLC · Port Orange, FLN733HSSprague Daniel W · Roseburg, ORN733HTBrazos Valley Flight Services LLC · College Station, TXN733HUStoughton Trailers Inc · Stoughton, WIN733HZFranco Scott A · San Jose, CAN733JALakewood Investments LLC · Victorville, CAN733JCKrogh Michael L · Lees Summit, MON733JEHagerstown Flight School LLC · Hagerstown, MDN733JFJones Atticus · Salt Lake City, UTN733JHRiverside Flight Academy Inc · Riverside, CAN733JLFordem Richard P Trustee · Borrego Springs, CAN733JMThunderbird Aviation LLC · Littleton, CON733JPMarc Aircraft Holding LLC · Soldotna, AKN733JSSchool Of Missionary Aviation Technology · Ionia, MIN733JTCl Habitat Management LLC · Salisbury, MDN733JWSeven 4 Zulu LLC · San Diego, CAN733KBGalion Air Inc · Galion, OHN733KCVan Anda Aviation LLC · Apopka, FLN733KEStettenbenz David A · Wasilla, AKN733KGNesher Aviation LLC · Jacksonville, FLN733KJGaffney John · Lauderhill, FLN733KKBend Aircraft Mechanics LLC · Bend, ORN733KSChaffin Grant M · Blythe, CAN733KTCardin Thomas W · Kearney, MON733KVSutton Aircraft Salvage LLC · Palmer, AKN733LEChagres Flight Training LLC · Albuquerque, NMN733LFPerfect Speed LLC · Burlington, MA
Back to Cessna 172N