AD 81-18-04 R2
Registered aircraft · 81,733
Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.
Query with SQL
duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2')
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, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2') ORDER BY n_number
Run 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.
N6808WClear Blue Aviation LLC · Melbourne, FLN6809NScott Shawn C · Granbury, TXN6809PMerino Cesar · Washington, DCN6809UVan Wormer Willard D · Leavenworth, KSN680ABPiper Aircraft Inc · Vero Beach, FLN680CDFly Mnt LLC · Glenview, ILN680DMGreen Daniel P · Westcliffe, CON680FLSchrimpf Robert · Batesville, INN680FPEisert Fred J · Yellow Springs, OHN680KTalos Aviation Group LLC · Blackstone, VAN680LHChristiansen Aviation LLC · Wilmington, DEN680MAChristiansen Aviation LLC · Wilmington, DEN680MGKennedy Arthur · Clovis, NMN680NDMedary Aviation LLC · Brookings, SDN680PMN680pm LLC · Knoxville, IAN680SQualitair LLC Trustee · MichelstadtN680SHSouthern Utah University · Cedar City, UTN680TFAir Fleet Holdings LLC · Addison, TXN680VDarley Vern · Peachtree City, GAFirst renewal noticeN680WWilkes Steven E · Wichita, KSN680XLipinski Glen E · Chandler, AZN680ZKalisz John B · Newhall, CAN6810De Young Ryan · Ten Mile, TNN6810DRawdon Robert C Jr · Hohenwald, TNN6810POlmedo Refugio J · Lancaster, CAN6810VMaxson Gerald M · Hawthorne, FLN6810ZAlbuquerque Soaring Club Inc · Albuquerque, NMN6811Dinnerbell Farms LLC · Eden, WIN68111Murphy Frank · Thomasville, GAN6811HJohnson Larry P Jr · Waynesville, GAN6811JRodgers Byron D III · Alexandria, VAN6811KBashore Charles A · Madison, ALN6811NVan Koetsveld Ernst J · Alexandria, VAN6811PStewart Steven L · Campbellsburg, INN6811UColeman Ronald R · Walla Walla, WAN6811WKlaerner Donald John · Fredericksburg, TXN6812NGrandruitt Rory Allen · Wadena, MNN6812PBrownfield Bruce Stuart · Oak Park, CAN6812UAll Things Guns LLC · Westfield, WIN6812VMoita Robert Jimizez Jr · Templeton, CAN68137Wind Walker LLC · Tucson, AZN6813LKing Robert B · Sheridan, WYN6813UShelton Timothy · Salisbury, NCN6813VEastern Stearman Inc Trustee · Leesburg, VAN6813WRotor And Wing LLC · Tioga, NDN68141Erb William F · Oakdale, CAN6814BMensing John P · Country Club Hills, ILN6814HUniform Gulf Aviation LLC · Williamstown, NJN6814JTavzel Aviation LLC · Portland, INN6814NMckenna Terence M · Scotts Valley, CA
Back to AD 81-18-04 R2