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.
N9887VDarby Holly M · Midland, TXN9889QTack-Morse Patricia M · Sweet Home, ORN988BGMojo Flight Group LLC · Gainesville, GAN9892QLytle Jack J · Omaha, NEN9893QDougherty Casey · Rock Island, WAN9894QKarpov Konstantin A Trustee · Fort Bragg, CAN9895QCk Leasing Services LLC · Wilmington, DEN9895VTogo Aviation Services LLC · Palmer, AKN9897QAbove All Aviation Inc · Santa Barbara, CAN9898QSecond Wind Aviation Corp · Friday Harbor, WAN9899QBrown Richard K · East Falmouth, MAN989CWCardinal Wings Aviation LLC · Buckner, KYN9900QBedsole Clinton Allen · Frisco, TXN9902QBowers John E · Owasso, OKN9903VDwh Flight LLC · Spring, TXN9904QStanford Jay J · Saint Marys, GAN9904VStratus Aviation LLC DBA · Vacaville, CAN9905QCentral Air Service · Lewistown, MTN9907QPlasco Designs Of Arkansas Inc · Texarkana, ARN9909QCk Aviation LLC · Charlestown, INN9910QTevebaugh Dennis J · Elkhart, KSN9911QAeronautical Technical Service Inc · Collierville, TNN9912QKd Aviation LLC · Sheridan, WYN9914QVictor Aviators Inc · Kernersville, NCN9917QStill Flying LLC · Gibsland, LAN9918QCerqueira Luiz Fernando · Orem, UTN9919QBlomstrom Andrew R · Oregon, WIN9920VSkywarrior Flight Training Inc · Pensacola, FLN9924QMy Way Aviation LLC · Weston, FLN9924VEdwards Kevin M · Grass Valley, CAN9925QRoeder Cara R · Lake Charles, LAN9925VGoodin Joshua W · Jacksonville, FLN9927QAndrus Shane · Pullman, WAN9928QDavis John · Jackson, WYN9931QDexter Aero Club Inc · Stetson, MEN9934QDoupe Services LLC · Fort Myers, FLN9935VD & S Aviation LLC · Wilmington, DEN9936QHunt Richard M · Columbus, OHN9936VLeading Edge Flight Academy LLC · Bend, ORN9937QFosmo Richard E · Eatonville, WAN9940VSoco Aero Leasing LLC · Santa Rosa, CAN9942QWarren John Russell · Los Alamos, NMN9943QGrove Todd M · Lake Stevens, WAN9944QSkywarrior Flight Training Inc · Pensacola, FLN9945QClassic Air Aviation LLC · Mesa, AZN9946QHorizon Aviation LLC · Sinclair, MEN9951V9951v Aircraft Leasing LLC · Spanish Fork, UTN995JAN995ja LLC · Ft Lauderdale, FLN9961VCk Leasing Services LLC · Wilmington, DEN9966VLeisner David L · Palmer, AK
Back to Cessna 172M