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 ('2072738', '2072739')
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 ('2072738', '2072739')
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.
N3502QHarvest Aviation LLC · Yorba Linda, CAN35106Bradley Patrick C Trustee · Isleton, CAN3518WMoriah Hills LLC · Aurora, ORN3519FVan Bortel Aircraft Inc · Arlington, TXN351SSGill David · Bellingham, WAN35206Mosaic Aviation LLC · Pelham, ALN35261Walrath Aviation LLC · Tacoma, WAN35265Turley Matthew Neil · Magnolia, TXN3530ZWilliams Alan G · Sterling, VAN35312Lam Raymond · Orlando, FLN3533NHouck Rex S · Coxs Creek, KYN3533WLongfellow Aviation Inc · Mequon, WIN3535PSchroder Urban · Fort Mitchell, KYN35370Dans Land LLC · North Little Rock, ARN3537WPlane Fun Inc Tr Trustee · Snellville, GAN3538BWisman Craig B · Saint Augustine, FLN3541FChandler Gregory E · St Albans, WVN3548AKunard Kevin L · Pinedale, WYN3549HSouthern Aircraft Consultancy Inc Trustee · Casper, WYN3553DM&R Aircraft LLC · Wilmington, DEN3556ZJohnson Paul A Trustee · Bloomfield Hills, MIN3560GVan Bortel Aircraft Inc · Arlington, TXN3635S2nd Chance Enterprise LLC · North Haledon, NJN369TCSchach Barbara G · Kirkland, WAN36TPEichenour Daniel L · Willis, TXN373WDBeardall Ann · Kiowa, CON3776TFractional Villas Inc · Del Mar, CAN378MSJulius Kaleb · Tucson, AZN379BFDay Darrell Rodney · Sahuarita, AZN379GPGreat Pacific Aviation Services Inc · Grants Pass, ORN379SAAerofeather Aviation Inc · Suffolk, VAN384EAMatisoff Noah · Helena, MTN3852BGromley Kevin M · Farmington, MIN385TCLiebl Holdings LLC · Claremore, OKN387TCBass Joel W · Okeechobee, FLN389HMHausmann Aero LLC · Grand Forks, NDN38PCLake Day Ventures LLC · Missoula, MTN38WRCds Worldwide Consultants Pllc · Birmingham, MIN396MCJf Aviation LLC · Minot, NDN397MWMccann Shawn Edward · Newton, NJN39BBHammonds Willard H II · Corpus Christi, TXN400KXSpritzair LLC · Durham, NCN400USUnited States Aviation Underwriters Inc · Millington, TNN405CCLussier Michael N · Sutton, MAN405TBPiland Donald A · Gulf Shores, ALN405TTGramling Terry Dewayne Jr · Corinth, MSN406LBSky West Aviation Inc Trustee · Albuquerque, NMN406VCVercruyssen Max · Honolulu, HIN411DRParkway Investments LLC · Rexburg, IDN412BWGms Storage Solutions LLC · Lake Oswego, OR
Back to Cessna T182T